I have a worksheet that contains a unique ID in column B. In column G there is other associated data. How do I combine the several rows of data in column G into one cell? Example of column B and G:
1 ASDF
1 SDF
1 ADSF
1 ASDF
2 ASDF
2 ASDF
2 DFASDAS
2 ASDF
So I'd want all of the data associated with unique ID 1 in a single cell, but not in one long string.