keep all data in order - power query

[bobaol]

Hi, i have 6489 txt files. all the same structure, same columns, same column names. But with different number of rows for each file, and with a ton of garbage inside it. garbage include empty rows at various rows. my questions is, how do i get the data so it comes back in order. for example, let's say I have fileA, with ten rows. I have fileB with 15rows. both files contain empty rows somewhere between the first row and last row. How do I get the data so it shows FileA row2 regardless if empty, fileA row3 regardless if empty. then when finished with FileA, have the same situation for FileB, and so forth. So, i want to show FileA row 1 to 10, then FileB row 1 to 15, in the order it shows in the txt file. I need those empty rows, and i need it to be in the order as it exist in the txt file. I am new to this PowerQuery thing (thanks to people here in MrExcel). It looks very promising. Any help is appreciated. thanks in advance.

 

[alansidman]

Whatever you designate in your source as your data range or table will be brought into PQ whether there are blank rows in that range/table or not.

 

[bobaol]

Thanks! it worked as you stated. must be my user error on the first try. A Light that Will Never Go Out: Am Yisrael Chai. cheers!