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

  • #2
    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.
    Alan

    Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
    FORUM RULES----->http://www.ozgrid.com/forum/announcement.php?f=8

    If someone has helped you, say "thank you" by clicking on the Like Button.

    Comment


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

      Comment


      • #4
        Any update?

        Comment


        • #5


          Anyone willing to help?

          Comment

          Working...
          X