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...
lmath1875
Sep 30, 2024Copper Contributor
SergeiBaklan where would I enter the mentioned steps on Excel Power Query?
Would It be as a add custom column?
Lorenzo
Sep 30, 2024Silver Contributor
Steps provided by SergeiBaklan must be added with Power Query Advanced Editor (option on the Home tab)