Hi I am looking for some help with an excel task. We have a spreadsheet that has data on multiple rows that we'd like condensed into one row. The rows have the same unique ID but a different number of rows of data. We'd like to be condensed onto one row, and then the duplicates names removed.
Column A has the unique ID that ties all the records together. Here is an explanation of the Record Types (column C):
LED - This is the lead's creation date.
CAL - Contains contact info like email, phone, and address
GRP - What groups the lead was in
CMP - What campaigns the lead was in
NOT - Notes entered for the lead