Concat Unique. Ignore Blank Cells?

I need to concat rows with the same SKU Number.

  1. Columns have extra delimiters from concatinating blank cells.
  • I replaced blanks/whitespaces before Unique.


  1. Dedupe leaves empty rows, which would lead to the same problem.


You should be able to use Replace to remove extraneous commas:


Perhaps we should have an option to ignore empty when concatenating in Unique.

1 Like