Breaking out Adjustments By Account into Multiple Columns

[WishIKnewHowToCode]

Hopefully this is simple enough to answer, I feel so stupid not knowing how to do this. A particular manager wants the data in this format, and I do not know how to do it easily. I have a file with account numbers and adjustment codes, and adjustment amounts. An account can have many different codes.

Apologies, to replace my values with dummy values in the dataset I have would just take too long. I think this is simple, and I'm just stupid?

The ideal output should look like my below table. Can anyone help me out? 

Account	Adjustment Code 1	Adjustment Code 2	Adjustment Code 3	Adjustment Code 4	Adjustment Code 5	Adjustment Code 6	Adjustment Code 7	Adjustment Code 8
999999	0	0	699.8	0	0	0	0	0
1111	0	1434	0	0	0	0	0	0
22222	0	254.04	0	0	0	0	0	0
3333	0	518.59	0	0	0	0	0	0
44444	0	0	140.19	0	0	0	0	0
555555	0	111.88	0	0	0	0	0	0
999443999	0	1582.16	0	0	0	0	0	0
3432423	0	188.15	0	0	0	0	0	0
12414	0	1558.33	0	0	0	0	0	0
12421412	0	0	96.56	0	0	0	0	0
34535324	0	1568.89	0	0	0	0	0	0
54647444	0	452.12	0	0	0	0	0	0
456546	0	1626.85	0	0	0	0	0	0
45754745	0	1779	0	0	0	0	0	0
876967	0	6224	0	0	0	0	0	0
087978987	0	0	120.06	0	0	0	0	0
324141	0	0	144.62	0	0	0	0	0
2345562	0	1572.92	0	0	0	0	0	0
2343233	0	1556	0	0	0	0	0	0
66435445	0	6986.66	0	0	0	0	0	0
65765765	0	67.27	0	0	0	0	0	0

[DavidSkaife · Accepted solution]

Hi @WishIKnewHowToCode 

The Cross Tab tool is what you need - group by Account, make the Adjustment Code column your new column headers, and the values the values for new columns. aggregating can be sum.

You'll need to do some column header renaming etc to get it in the exact format, but this should help get it laid out how you want.

[WishIKnewHowToCode]

Lifesaver, thank you. I just fundamentally misunderstood how to use the cross tab tool. I had tried a few times and couldn't realize what I was doing wrong.