Combining files side-by-side

[TheSithSiggi]

Hi!

Suppose you have X-number of files, and would like to combine data from sheet1 in all files into 1 file with the data presented side-by-side.

The data I have is on the form

A B C D
x x x x
x x x x
. . . .
. . . .
. . . .
. . . .

The number of rows can vary between the files

I would like the end result to look like:

File 1 | File 2 | File 3
A B C D A B C D A B C D
x x x x x x x x x x x x
x x x x x x x x x x x x
. . . . . . . . . . . .
. . . . . . . . . . . .
. . . . . . . . . . . .
. . . . . . . . . . . .

I have managed to stack the data untop of each other i power query.

Does Power Query support "sideways stacking"?

Thank you!

 

[Matt Allington]

If you name all the columns uniquely across the 3 files, then append, they will be side be side, but maybe not they way you want it.

 

[axeaxeaxe]

Hi, came across this question while looking for it myself. A solution is to transpose the sample file. In the combine transpose again and the files will be side by side.