I need to concat rows with the same SKU Number.
- Columns have extra delimiters from concatinating blank cells.
- I replaced blanks/whitespaces before Unique.
- Dedupe leaves empty rows, which would lead to the same problem.
I need to concat rows with the same SKU Number.
You should be able to use Replace to remove extraneous commas:
Perhaps we should have an option to ignore empty when concatenating in Unique.