Dedupe + merge without duplicating values in cells

Ask a question
3

SOLUTION (might be some simpler ones):

  1. Unpivot the table to create rows which are ID | TYPEOFDATA | VALUE.
  2. Merge the three columns to create unique values in a NEWCOLUMN
  3. Dedupe NEWCOLUMN, no merging
  4. Filter rows with blank values in VALUE
  5. Pivot
  6. Merge rows according to ID
  7. Find double commas and replace with single commas
  8. Regex to replace /^,* and [*,]$ with nothing.

I wouldn’t have had to do this if there was an “ignore blank” and “don’t merge identical values” in the dedupe step. Might be a good feature, but I already asked for a new feature yesterday. :innocent:
[/quote]