Dynamically stack input data horizontally
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks. That was way too quick.