I have a data source of product data, which looks like this.
Input
"STYLE NUMBER","ACTIVE COLOR CODES","ACTIVE COLOR NAMES"
"160","2, 1","Grå, Hvid"
"16090","10, 2","Sort, Grå"
In this case each style has 2 colors. Defined by color codes and by a localised color name. Some products have many more colors.
I would like to get new rows where I have each style as a separate row for each color.
Desired output
"STYLE NUMBER","ACTIVE COLOR CODES","ACTIVE COLOR NAMES"
"160","2","Grå"
"160","1","Hvid"
"16090","10","Sort"
"16090"","2","Grå"
The here are many more columns in the data but I have only included these 3 in the example data.
This is the final update, removed the need for regex in Replace, as that require change in regex, if let say there are extra characters or symbols in the data, and as regex is not that simple, came up with new solution which is simple without the regex.