Power Query: Combine Files, delete row1, promote row2 as headers

SOQLee

Board Regular
I'm trying to combine files in PQ that have an extra row above the headers.

How would I combine these files by deleting Row1 and promoting Row2 as headers?


Count5
IDActionDate
11111INP18-Oct
22222INP19-Oct
33333INP20-Oct
44444CLOSED21-Oct
55555INP22-Oct

<tbody>
</tbody>

Count3
IDActionDate
66666CLOSED18-Oct
77777INP19-Oct
88888INP20-Oct

<tbody>
</tbody>
 

sandy666

Well-known Member
sure but we don't know your wonderful M functions and queries with parameter
 
Last edited:

SOQLee

Board Regular
1. Save all the files in the same folder

2 On the Excel 2016 menu bar choose Data-->New Query --> From File --> From Folder

3. After choosing the folder; choose the Combine & Edit . Choose OK in the next screen.

4. Go to Workbook Queries editor and select the Transform Sample File. This is the base table for the formula you create prior to work. Make all changes here. Remove first row, promote headers...etc.
 

sandy666

Well-known Member
I don't see any M function and any parameter, :confused: but if it works for you that's great

have a nice day
 
Last edited:

Some videos you may like

This Week's Hot Topics

Top