Concatenate Question

[alexlyle]

I have a list of codes, levels, and types( see below). I need to concatenate them but if there is more than a certain number, I need them to be in a new row.  Below, i have 3 codes. One occurs 5 times. One 4 times. One 3 times. How would i limit it so that each row only has 3 occurrences?

I want

Code	Level	Type
Code1	1	10
Code1	2	12
Code1	3	16
Code1	4	02
Code1	5	01
Code2	1	12
Code2	2	16
Code2	3	02
Code2	4	01
Code3	1	12
Code3	2	16
Code3	3	02

to become

Code	Level	Type
Code1	1,2,3	10,12,16
Code1	4,5	02,01
Code2	1,2,3	12,16,02
Code2	4	01
Code3	1,2,3	12,16,02

filling out rows with blank spaces is fine

[Aaron_Harter · Accepted solution]

@alexlyle, 

You'll be able to use the concatenate function of the Summarize tool once you assign the group # for each code, to limit the max number of records for each group to 3: