HELP!!! Repeat count when other column repeat

[jjimenez]

I need help to group the below mentioned names by university, study, tuition and country. The way I was thinking was to add a count that repeats at name (highlighted below) so I could create columns for each person. Then I could use the Cross Tab / Transpose tools to get each person and their information in 1 column.

I can't figure out how to use the Record ID tool to repeat numerically upon the change of name. 

Any advice would be greatly appreciated. 

[jjimenez]

My ultimate goal will be to filter down by the TOP 5 students with highest tuition and what countries they are in

[Luke_C · Accepted solution]

Hi @jjimenez 

I've attached two methods here. One is what you describe and the other is what I would recommend:

Both use the multi-row tool to create a grouping 

[jzkyburz · Accepted solution]

@jjimenez , if I understand your inquiry correctly, you should be able to accomplish this with a multi-row formula tool:

Check the attached example workflow with your data to see if this is what you need.

[jjimenez]

Luke - Thank you so much. This was very helpful.

Do you do any tutoring on the side? Been studying and practicing for exam #2 (for the 2nd time) :)  

[Luke_C · Accepted solution]

Hi @jjimenez 

Happy to help - please be sure to mark the solution.

My best advice for the advanced exam is to review the prep guide and do plenty of weekly challenges.