To any formula ninjas,
A column has multiple keywords/values. I need to add a pre-fix before each of the values.
values: White, Black, Blue
To: add the prefix “Colour_” to each one of the values in the colour
values: Colour_White, Colour_Black, Colour_Blue
I created another column with the prefix Colour_, and then a basic concat, but the result is (of course):
Colour_White, Black, Blue
I don’t know how to add the prefix to each of the values individually, and if concat is the right formula.
Detail: not all columns will have a value, so need to consider an empty cell.
If anyone has a good idea… much appreciate it !