- Can I Concatenate columns in a different sequence?
- Can I put a different delimiter between each column?
I need to combine these columns, but the different delimeters, “#” and “-” is making me go very long route.
[Brand] [Type] [#][Color Number] [Color Name] [ - ] [Product Line]
- List item
- Concatenate: Brand + Type, with a space delimiter = “BrandType”
- I can’t concatenate the next sequence (Concatenate BrandType + Column Number, with [#] delimiter) because the new column, “BrandType” is added as the last column.