Forum Discussion
cimrman65
Jan 30, 2024Copper Contributor
Power Query: extract data from tables into multiple columns
Hi, I have multiple excel files with 3 columns that I want to merge into one sheet. If possible, I would like to have one empty column between each 3 columns. I figured out I would use power query fo...
SergeiBaklan
Jan 31, 2024Diamond Contributor
In theory that's possible, however it's better to have simple sample file. The only, Power Query returns structured table. Since table can't have repeated headers, they will be like Load1, Load2, etc for each first column, for empty columns it could be Balnk1, Blank2, etc. or so. Could be variants, but in any case each header shall to have it's own unique name.
If you are on Excel 365 perhaps it's better to use formulae and HSTACK all table. Details depends on what are source tables, are they dynamic (number and names) or not.