Promote headers in source step

[kylerwimbush]

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. 

[#2]

@kylerwimbush 

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