Grouping Records?

Question

Hey, all!

I am attempting to create a unique listing of records that are differentiated by the record group from the first column. Ultimately, what I want to do is group records in a way so that the individual records are populating underneath their main group. Attempting to avoid using a combined solution of filter / dynamic rename / join due to the number of filters that it would require.

Below is a brief example of what I am attempting to accomplish using basic data:

Any help would be appreciated. Thanks in advance!

OllieClarke · Answer

@ridodson another approach if you don't have the same number of strings in each code is to use a multi-row formula tool

If you group by Code in the multi-row, then you can do a recordId which restarts every new code

Everything else is identical to @binu_acs' solution :)

Ollie

binu_acs · Answer

@ridodson  oneway of doing this with the tile tool

in the tile tool select the equal records and specify the group of records you want (total records / 5)

Grouping_21_07.yxmd