0

I have an Excel file, first 7 rows are merged. Others are unmerged. I need to load unmerged rows from Power Query but Excel brings first merged colums and I cannot change/remove.

enter image description here

First 7 rows B and C Columns are merged. Powerquery loads these rows only which I do not need.

When I manually unmerge these columns Power Query loads correct table. I don't want this manual operation each time.

I need rows starting from 9.

Regards,

I've tried every solution from this site and ChatGPT but didn't solve my problem

-- Edit: I've realized that problem is auto generated Excel source file. When I open and save source Excel file withot changing anything, power query loads all rows and I can skip top rows. Now I try to figure out to automatically fix auto generated source Excel file.

Thanks for all replies.

Improve this question
2
  • Please try this solution Commented Sep 11, 2023 at 12:23
  • Thanks for your reply. I do not have problem with CSV files. Source is Excel file. Commented Sep 11, 2023 at 13:39

2 Answers 2

Reset to default
2

In powerquery, read in the data, then do

home ... remove rows ... remove top rows ... 8

then

home ... use first row as headers

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Thanks for your reply but that is not my question. First 7 rows in original Excel source are merged and loaded only this part. When I remove top 7 rows it remains empty. Power query doesn't load rows after merged rows.
Please edit your question and paste in your code from home ... advanced editor. Also provide a sample copy of your data input if that image is not it
0

Two options:

  1. Manual: select your table range and through right click select "Get Data from Table/Range..." enter image description here

  2. Auto (if you don't want to select table range manually): described here (I added excel load example together with csv)

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.