Split rows to new rows with using data from 2 cells

Question
1

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.

How can this be done?

2

It’s not very pretty. But neither is your data. ;0)

image

jh.transform (4.9 KB)

3

Thanks. I know the data is not pretty. But it is what I have been given :slight_smile:

1 Like
4

Here is a solution that will cater that

image
image493×645 48.4 KB

Transform file.
SplitRowsToNewRows.transform (4.9 KB)

2 Likes
5

Thanks. This works for all. I forgot about the ones with more than 2 colors myself.

1 Like