Hi Community,
I'm not sure how to ask this, but I have a list of 1st values which repeat.
And a list of corresponding 2nd values.
I need to amalgamate the 1st values and count them, then transpose the list of 2nd values for the 1st values.
I'm sure there is a better way of explaining, but attached is a sheet. Column I is manually created, but it contains the data as I need it.
Hopefully I have made it clear enough within the file.
Bookmarks