Sort data challenge-Normally one row w various columns of info -What if items have multi-rows?

[Kiernan_Convey]

Sort data challenge-Normally one row w various columns of info -What if a singular item, like a name roster, was assigned multiple rows?  How does sort not get corrupted in full document?

[#2]

Hi @Kiernan_Convey 

Use RecordNumber

example:

record 01 has 2 rows associated with it, then the record number would be:

01-1

01-2

if record number has 3 rows associated with it then:

02-1

02-2

02-3

and so on and so forth