Ex Excel II

Request: For a mailing we need to summarize data for each recipient. I have one line or multiple lines per person, each line having three columns: id, property, value. For each person, take the first line (in case of multiple lines per person) and create a new column called summary. The column summary contains all properties and values for that individual (use delimeter ” – ” inline, and “</br>” between lines). If value is empty, just take property (and don’t use ” – “) and combine with other lines as appropriate.

Image 1. Some persons (ids) appear multiple times.
Image 2. Desired output with one line summarizing data for each person/id.

Try it yourself: use this file template and upload your input file (.xls, .xlsx, or .csv) using below form (with default solution S00002).

[Form Placeholder]

Custom solution: adminautomated.com/excel