I have a column of data that could have several hundred numerical entries in it with duplicates up to the number 288.
The column to the left is labeled top to bottom 1 through 288.
I'd like to middle column (where the large list resides) to sort and concatenate duplicates separated by a comma in the adjacent cell to its corresponding number. Then in the right side (of three columns) to count the amount of concatenated numbers in the middle column (if any).
Any help is appreciated.
Please see the spreadsheet to visualize what I'm looking for.