SOLVED
Change month columns into multiple rows and columns
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
canddig
6 - Meteoroid
‎04-08-2022
03:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am trying to figure out how to take month columns and make them rows but keep the month they belong to as a value in the row. I need to keep the columns that they are but have the rows notate the month they belong to. Here is an example of my data and the out put I am trying to achieve.
Thanks,
Candace
Current Format
Expected Output
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Data Investigation
- Help
6 REPLIES 6
binuacs
21 - Polaris
‎04-08-2022
03:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@canddig can you provide the sample data in excel?
‎04-08-2022
04:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes!
binuacs
21 - Polaris
‎04-08-2022
04:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Tiffyyy
Alteryx
‎04-08-2022
04:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
danilang
19 - Altair
‎04-08-2022
04:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎04-09-2022
05:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you all so much. I was able to move this from sample data into production and it works great. I appreciate your time and efforts on this, I literally couldn't have done it without you.