Announcement

Collapse
No announcement yet.

Condensing data in multiple rows down to a single row based on a unique identifier

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Condensing data in multiple rows down to a single row based on a unique identifier

    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
    Attached Files

  • aja6556
    replied
    Anyone willing to help?

    Leave a comment:


  • aja6556
    replied
    Any update?

    Leave a comment:


  • aja6556
    replied
    Attached is an example of what we'd like the final product to look like.
    Attached Files

    Leave a comment:


  • AlanSidman
    replied
    Provide us with a mocked up version of what your results should look like as your explanation is not quite clear on that. Do not post a picture, but upload a worksheet. We cannot work with pictures.

    Leave a comment:

Working...
X