SOLVED
Create a table out of a matrix
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
jpavlick
6 - Meteoroid
‎03-10-2021
11:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a data set where the first column lists states, and subsequent columns list files and amounts corresponding to each state. I want to make each amount its own "record" with associated file and state. I have attached an example.
Solved! Go to Solution.
2 REPLIES 2
17 - Castor
‎03-10-2021
11:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jpavlick ,
Here it is, you can use the transpose tool to accomplish that.
Best,
Fernando Vizcaino
17 - Castor
‎03-10-2021
11:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
