I have a worksheet with different names. Each name might have 1 to 5 rows with comments. I want all the comments on the first line. For example:
SSN NAME COMMENT COMMENTATOR
001 PERSON1 COMMENT1 JUDGE1
001 PERSON1 COMMENT2 JUDGE2
002 PERSON2 COMMENT1...