I have some data that has a column for a name and within that column there could be multiple rows with the same name as well as rows with different names, see screen shot. each row will have further columns with other data. I need to be able to filter rows to group the rows with the same name but can not work out how to do it. as you can see from the screenshot I have managed to add row numbers based on the name column. Now I need to separate out the names into different columns/arms of my flow. This is just a sample of data, there will be differing amounts of rows with the same name. In the screen shot you will see that the rows current run from 1-10 for each name.
What would be handy is if you could add row numbers based on a certain column as you can, but you could choose to have the same row number for the same name. So Chic/Mack would be row number 1 and Chic/Sal would be labelled 2. Then you would be able to filter the rows by number. If anyone can tell me how to do that, or acheive what I am aiming to acheive, I would appreciate it.