Combine multiple files with one different header

[leediles]

I have 60+ files that I need to regularly combine into one and do a bit of formatting on. I have tried to use Get Data From File/Folder for this, and it almost works, except that each file has a unique value in cell A1, followed by the true headers in row 2 which are the same in all files. When I combine the files, I only get the values from column A in the first file and the rest all show null.

Is it possible to skip the first row before combining the files so that the headers match?

[#2]

@leediles 

Edit generated Transform Sample File query removing 1 top row

and after that Use first row as header

Resulting query shall return correct result after refresh.