Combine multiple files with one different header

%3CLINGO-SUB%20id%3D%22lingo-sub-1700534%22%20slang%3D%22en-US%22%3ECombine%20multiple%20files%20with%20one%20different%20header%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1700534%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%2060%2B%20files%20that%20I%20need%20to%20regularly%20combine%20into%20one%20and%20do%20a%20bit%20of%20formatting%20on.%20I%20have%20tried%20to%20use%20Get%20Data%20From%20File%2FFolder%20for%20this%2C%20and%20it%20almost%20works%2C%20except%20that%20each%20file%20has%20a%20unique%20value%20in%20cell%20A1%2C%20followed%20by%20the%20true%20headers%20in%20row%202%20which%20are%20the%20same%20in%20all%20files.%20When%20I%20combine%20the%20files%2C%20I%20only%20get%20the%20values%20from%20column%20A%20in%20the%20first%20file%20and%20the%20rest%20all%20show%20null.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20skip%20the%20first%20row%20before%20combining%20the%20files%20so%20that%20the%20headers%20match%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1700534%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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?

1 Reply

@leediles 

Edit generated Transform Sample File query removing 1 top row

image.png

and after that Use first row as header

image.png

Resulting query shall return correct result after refresh.