Merging Multiple Tabs into One Spreadsheet with Formatting

kv-defy

I am currently working on data in multiple excel tabs. 

I have successfully cleaned and formatted the dataset for 1 tab with a current workflow. 

However, I have multiple tabs which I want to combine them into 1 spreadsheet using Alteryx. However, I do not know of the fastest and efficient way of doing this because Alteryx's input data only takes in 1 tab at a time. I have more than 50+ different tabs (countries) to clean and format the data. I would like to combine them into 1 spreadsheet.

Current data format:

	2021	2020	Variance	... (more columns)	Variance %
Revenue
IT Cost
... (more rows)
Other Costs

 (sample, there are more than 50 tabs to merge together)

Desired data format:

	2021	2020	Variance	... (more columns)	Variance %
Revenue
IT Cost
... (more rows)
Other Costs

with the other countries' data tab combined into 1 spreadsheet.

Is there an optimal way of doing this? Kindly seek help and understanding 😊

grazitti_sapna

Hi @kv-defy, you can do it with the help of macro. 

Firstly, I have taken an input just for sheet names.

Then passed it through the macro to get the result from all the tabs.

You can simply replace the input source with your source and then follow the configuration from the first screenshot.

PS: You might have to make some tweaks as per the requirement. This workflow is a generic approach.

I hope this helps!

Thanks!

ky-defy_workflow.yxzp