Forum Discussion
Promote headers in source step
Working with power query and in the source step, you can change null to true to promote the first row of your excel workbook to the header.
what I need to do is repeat that step 2 more times,
so that the row starting with wave, queue, dtm, and so on become the header. any help? thanks.
1 Reply
If you don't need to first 2 rows and expect the 3rd one as Header, just skip the first 2 rows
In Power Query Editor > Home Tab > Remove Rows > Remove Top Rows
Then Promote Headers
