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.
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