Forum Discussion
Source data has header titles on different rows
Hi, are the rows before your header blank? If yes, you can remove the blank rows, transpose the table, merge the two columns you want to be the header, transpose the table again and finally promote the first row to be headers.
Hello Omid and CaptOdyssey,
Apologies, but I don't think I explained myself properly.
My issues is that the 5 source files have the report/header titles starting on different rows in each file. I want to use Power Query in Excel to combine the 5 files together with the header titles being the first row. As the 5 source files have the header/report titles on different row numbers, I am unsure how to do this. Also, the 5 source files have other data above the row which is the report/header titles which adds to the complication.
I hope I've that more clear.
