Hello,
I'm hoping there is a formula I can use to accomplish my need. I have a list of numbers in column A, and an associated Reference number in column B. If the number in column A is duplicated in multiple rows, I need the reference numbers in column B to concatenate into a single field in column C.
Sample data attached.
Cells A5 and A6 have the same Lot Number (53). So I need the reference numbers in Cell B5 (CID3121300038) and Cell B6 (CID3121300039) to concatenate in C5 (CID3121300038, CID3121300039).
Bookmarks