Transforming data from vertical to horizontal

[dunkindonut7777]

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?

[atcodedog05]

Hi @dunkindonut7777 

You can use crosstab tool like this

Hope this helps : )

[RolandSchubert · Accepted solution]

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

[dunkindonut7777]

yes it worked. thank you