8 Replies Latest reply on Aug 14, 2019 9:44 AM by Deepak Rai

    Combine two rows into one and sum their values

    Cassandra Sherrill

      I have a huge file with many names and addresses. Some of them are written slightly differently, so they show up as separate entries, but they're actually the same place and should have only one entry. I need to combine the two slightly different entries into a single row, listing just the address or name that is the "correct" one and adding their values together.

       

      So I would want to take something like this (very simplified):

      Combine start.JPG

      And get something like this instead:

      Combine finish.JPG

       

      I can't seem to build a calculated field correctly for this. Many thanks for any insights!