Powerquery to go directly to a specific row in my data (instead of promoting headers multiple times)

[KristofferAJ]

Hi!

I have in several of my reports (if not all) promoted headers in various steps especially in excel reports where my raw data starts in row 11 for instance...

I wonder if there is a certain way to have powerquery to look directly in to "row 11" instead of me promoting headers 10 times in my powerquery?

[Riddhi_06 · Accepted solution]

To optimise this problem,
1) In the Power Query, In the Home Section->select Remove Top Rows 
You can select that option and enter 11 , and then top 11 rows will be deleted
2) Apply Promoted Headers now . By this, promoted header step is applied only once

[KristofferAJ]

simple and perfect, thanks