How to transpose multiple columns into one?
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
bryanmac_92
8 - Asteroid
‎01-22-2025
05:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am trying to see how to multiple columns into one where this data:
Inq | Transfer | Apps |
3 | 0 | 0 |
3 | 2 | 3 |
1 | 0 | 0 |
1 | 0 | 0 |
2 | 2 | 2 |
2 | 1 | 2 |
1 | 1 | 0 |
1 | 0 | 1 |
7 | 2 | 0 |
18 | 14 | 17 |
turns into
Metric | Value |
Inq | 3 |
Inq | 3 |
Inq | 1 |
Inq | 1 |
Inq | 2 |
Inq | 2 |
Inq | 1 |
Inq | 1 |
Inq | 7 |
Inq | 18 |
Transfer | 0 |
Transfer | 2 |
Transfer | 0 |
Transfer | 0 |
Transfer | 2 |
Transfer | 1 |
Transfer | 1 |
Transfer | 0 |
Transfer | 2 |
Transfer | 14 |
Apps | 0 |
Apps | 3 |
Apps | 0 |
Apps | 0 |
Apps | 2 |
Apps | 2 |
Apps | 0 |
Apps | 1 |
Apps | 0 |
Apps | 17 |
Labels:
1 REPLY 1
21 - Polaris
‎01-22-2025
06:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@bryanmac_92
A Transpose tool does the exact you need here.
I have added a small technique to get the data order as in your sample output.
