Excel Table Formatting Conversion

Question

Hi Alteryx community. I'm currently working on a project in Excel where I'm trying to convert a table from one format into another. I'm having trouble doing this in Excel so I figured I would try Alteryx.

I've attached a file of what I'm trying to achieve. Currently, the data is laid out like how it is in the tab "Template A" and I'm trying to move things around so it looks like the tab "Template B". Any ideas how to do this? I've tried transposing in Alteryx and doing a few other things but haven't had any luck. Thank you so much!

Alteryx Task Example.xlsx

Adrian_T · Answer

Hey @kfeng, definitely, you’ll be able to import data from all tabs by following the steps laid out in this helpful article under Import Multiple Sheets in one Excel File. Remember to select File Name in the drop down for “Output File Name as Field”.

These steps will replace the Input Data Tool in my attached workflow above.

kfeng · Answer

Wow that was quick, thank you so much!

Apologies but to add to the complexity a little bit... the Excel file I am trying to convert has about 15 tabs that are all in the format of Template A. I could probably run this workflow individually 15 times but is there a way to bring in all of the tabs, add a column with the name of the tab, and then use the workflow that you've attached to convert into Template B?

Adrian_T · Answer

Hey @kfeng,

Here's one way to do it - you were on the right track of exploring Transpose tools. I have attached the sample workflow as well.

Format Excel Table.yxmd