Hi all,
Just joined the community, so forgive me if I failed to understand any of the forum rules.
My current spreadsheet has 2 columns:
A contains Record Numbers
B contains Code
A B
Record Code
0001 AQ
0001 AW
0002 AR
0003 AR
0003 AT
0003 AW
0003 FD
0003 FS
0004 AT
0004 AX
0004 AR
0005 AW
There are duplicate rows for Record Numbers with multiple code entries without any consistency. One Record Number can have as many as 30 codes (and rows), or as few as one.
I need to somehow collapse those multiple rows into a single row, simultaneously taking the Code entries from column B and aligning them horizontally across multiple cells.
Example:
A B C D E F
Record Code Code2 Code3 Code4
0001 AQ AW
0002 AR
0003 AR AT AW FD FS
0004 AT AX AR
0005 AW
Thanks in advance!
Bookmarks