Combine worksheet with alternating ranges

Hello guys,

this might be simple to some of you but i just dont get any futher.

I have an excel file with 4 worksheets. All worksheets contain the "same tables" but with different values and one "key column". The key column for the first worksheet contains the letter A, the one for the second B, etc.

Now i would like to combine all 4 worksheets into one and have the ranges/rows alternate based on their key.

This means i want to start with the first row from the A worksheet, then put the first from B, etc.

In the end it is supposed to look like this: (Example)
9e1fcd1c509df93d02f5f9527f5d5e32.png

Is there any solution to this without having to manually do this for over 1000 rows?


Im open for any kind of solution, i tried power Query and a also VBA, but i dont have much knowledge in both.


Thank you in advance

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.