Dynamically stack input data horizontally

[sh0kat]

Problem : How to dynamically join input from different sheets horizontally. The workflow should be dynamic like when more sheets gets added to excel file the output should update accordingly.

Desired Output :

Col A and Col B are coming from Sheet 1 in excel file

Col C and Col D are coming from Sheet 2 in excel file

Col E and Col F are coming from Sheet 3 in excel file

It should be dynamic. If more sheets are added to the excel, then the first two columns of the sheets should be stacked horizontally. 

[fmvizcaino · Accepted solution]

Hi @sh0kat ,

Solution attached.

I'm using the transpose and cross tab tool to create the process of column creation based on filenames

Let me know if you need further assistance.

Best,

Fernando Vizcaino

[sh0kat]

Thanks. That was way too quick.