Power Query Merge multiple files in a folder, in columns not rows

[SteynBS]

Hi Guys,

I am using Power Query to merge multiple Excel files in 1 folder, but instead of throwing the data below the other in rows, I need it in columns.

So I have a master file that I will use as a seperate source called Master. The layout looks like this

I will then have multiple other excel files in a folder they will have different names, but they will all have the same layout:

What I need th achieve is all the files in the folder needs to merge with the Master file using the "item" as the join. The final product will look like this:

Currently what I am doing is using each file as a source and merging it to the Master file using the "item' as the join. Is there anyway I can achieve this in a faster way?

 

[Fluff]

Duplicate to: Merging multiple Excel files in a folder into columns, not rows

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.