SOLVED
Transpose / crosstab
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
lmaughan
7 - Meteor
‎03-18-2021
12:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need help in transposing the attached data --
Current data to Desired data tab.
Not sure if crosstab or transpose is the best tool to use for this. Thoughts and insights are welcome.
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
4 REPLIES 4
17 - Castor
‎03-18-2021
12:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The answer would be both! First transpose to get gross and reserve as rows, then crosstab by state:
Edited to fix column
17 - Castor
‎03-18-2021
01:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎03-18-2021
01:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So helpful! Thanks for responding so quickly... this is perfect!
‎03-18-2021
01:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is another great solution.. I love how you can take different approaches in Alteryx to get the desired result.
Thanks much for your help!
