SOLVED
Transforming data from vertical to horizontal
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
dunkindonut7777
8 - Asteroid
‎01-26-2022
11:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi I have a data here that presented vertically and I want it to arranged it according to the following:
Data:
Code | Period | Total |
12323 | 1 | 100 |
12323 | 2 | 4350 |
12323 | 3 | 132 |
12323 | 4 | 34 |
12323 | 5 | 435 |
12323 | 6 | 453 |
12323 | 7 | 43 |
43243 | 1 | 45 |
43243 | 2 | 455 |
43243 | 3 | 54 |
43243 | 4 | 54 |
43243 | 5 | 53 |
43243 | 6 | 4 |
43243 | 7 | 42 |
56567 | 1 | 43 |
56567 | 2 | 43 |
56567 | 3 | 43 |
56567 | 4 | 42 |
56567 | 5 | 43 |
56567 | 6 | 43 |
56567 | 7 | 43 |
Expected output:
Code | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
12323 | 100 | 4350 | 132 | 34 | 435 | 453 | 43 |
43243 | 45 | 455 | 54 | 54 | 53 | 4 | 42 |
56567 | 43 | 43 | 43 | 42 | 43 | 43 | 43 |
Basically, I want the values under period column to be the header also.
Can you help me with his one pls?
Solved! Go to Solution.
Labels:
- Labels:
- Adobe
3 REPLIES 3
22 - Nova
‎01-26-2022
11:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
16 - Nebula
‎01-26-2022
11:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @dunkindonut7777 ,
the Cross Tab tool is your friend to solve the problem:
You group data by code (i.e. rows), define period as the columns and are done.
Let me know if it works for you.
Best,
Roland
‎01-26-2022
11:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes it worked. thank you
