I have a sorted list with names in column A and page numbers in column B. I'd like to group the page numbers for the same person in the same cell. A person may have up to six pages. Any non-VBA method of doing it?
desired result | ||
Jill | 24 | 24 |
Joe | 17 | 17 |
John | 52 | 52, 99 |
John | 99 | |
Steve | 50 | 50, 66 |
Steve | 66 | |
Tom | 51 | 51, 88, 94 |
Tom | 88 | |
Tom | 94 | |