Cross-tab every n number of rows

[MB777]

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!

[RolandSchubert · Accepted 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