community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dual Category Rows in Excel

Alteryx Partner

Hi All,

 

I'm sure this is a simple one but I'm new to Alteryx, I have an Excel spreadsheet (attached) that has three rows for category (Main - Total, Age and sex, then 1st drill down for Age and sex - 16-24 etc and Men and Women, and then 2nd drill down for all - 2016, 2017). How do I transpose this so it is ready to go into Tableau?

 

Thanks for any help, even if its just an example for me to reverse engineer.

 

 

 

Alex 

Alteryx Certified Partner
Alteryx Certified Partner

There's a couple problems here, the headers being one and the indentation for a hierachy being the other. 

 

Also can you be clear on what you believe the output you are looking for should look like, perhaps mock up an example? 

Ben

Highlighted
Alteryx Partner

Hi Ben, I have attached the same file but have made a mock up sheet as an example, dont worry about the total column, I will just get rid of that and let either tableau or alteryx work it out  

Alteryx Partner

solved! 

Meteoroid

Hi,

 

How can you solve this? I have a similar problem.

 

Thanks.

Meteoroid

How to solve it?

Labels