Dual Category Rows in Excel
- 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
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
solved!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
How can you solve this? I have a similar problem.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How to solve it?
![](/skins/images/59DA3CA97FC6306BFE8B6DED203F3AC0/responsive_peak/images/icon_anonymous_message.png)