Hi!

Below/attached are two example files. First, I want to eliminate the first four rows and the last row in each file and then have the fifth row interpreted as the header row.
I played around with PowerQuery, now use "Combine & Transform" and understand the Query Settings Section, where I can set the rules.
But not sure where to enter what I want as described above.

Any help is much appreciated.

Thank you!

File No 1: CC_11.csv
File No 2: CC_12.csv