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.

image

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

image

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

regex

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

1 Like