Merging multiple Excel workbooks but not stack up them.

[RajatRehria]

Hi Team,

I hope my query finds you well.

My query is that i want to merge multiple excel files but I don't want to stack up them, what i am looking for is one dataset imported into alteryx and second dataset do not stack beneath instead placed on the right side. I can merger the multiple workbooks using Macros but the problem I am getting is that all datasets are stacking up which i am not looking for.

Note: All excel workbooks have one sheet only with exact same sheet name. Please refer the attached screenshots. Screenshot 3 is what I am looking for Many thanks. 

[Felipe_Ribeir0]

Hi @RajatRehria 

One doubt, the X's of different files must stay on the same row, right?

Please see if you can adapt this workflow to your situation, i tested it with 3 dummy files.

[RajatRehria]

Hi Felipe, thanks a lot for the prompt response, yes X, Y, Z remain in the same rows, however i also need the A, B, C, D, E, F etc. headings in my output. Thanks again 

[Felipe_Ribeir0 · Accepted solution]

@RajatRehria 

Ok,  check this updated version!

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[RajatRehria]

Hi Felipe, many thanks to you for solving my query :) I have accepted it as a solution.