My data is formatted like this:
Category | Product | Product-Segment | Value |
A | Apple | 1 | 10 |
A | Banana | 2 | 33 |
A | Orange | 3 | 55 |
B | Apple | 1 | 12 |
B | Banana | 2 | 44 |
B | Orange | 3 | 66 |
C | Apple | 1 | 77 |
C | Banana | 2 | 21 |
C | Orange | 3 | 63 |
I need to get it to look like this:
Product | Business Unit | A | B | C |
Apple | 1 | 10 | 12 | 77 |
Banana | 2 | 33 | 44 | 21 |
Orange | 3 | 55 | 66 | 63 |
I know I need to use Cross-Tab, but how do I get it so it pivots every 3 columns (all of the A's, all of the B's, all the the C's and makes an A, B, and C column)? In my data, it's consistent so that each category takes up 3 rows. I need to pivot these rows so they are columns instead.
Any help is appreciated! Thanks so much!
Solved! Go to Solution.
Hi @MB777 ,
in the Cross Tab tool, select "Product" and "Product-Category" as "Group by" fields, Category is header and Value is the field containing the values for columns, Method will be "SUM". I've attached a sample workflow.Hope this is helpful.
Best regards
Roland