CODEWITHSUNDEEP
excelpowerquery
myesil
myesil

Reputation: 1

Excel Power Query remove merged columns from Excel source before loading

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.

Upvotes: 0

Views: 285

Answers (2)

Denis
Denis

Reputation: 781

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)

Upvotes: 0

horseyride
horseyride

Reputation: 21318

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

Upvotes: 2

Related Questions