I am new to the forum and really a beginner in Excel.
I am trying to combine into 1 Excel Sheet about 20 files that are in the same folder (see file example attached).
I am using Power Query.
All the files have the same structure and I may add other files with the same structure to the folder other the coming months.
My challenge is that I want to consolidate the rows only starting from row 6 (data) and re-use Header from row 5.
Can you help me?