Reformatting the data

Tharashasank

Hi All,

I have a data set which is mentioned below  here i cannot do the split using a delimiter .i need it to be dynamic because there will be a case where we will have more than 20 separated (;) value.

Product id	error messages
1
2	a;b;c;d;e
3	b;a;c
4
5	x;y;z
6	d;e;f

I Want the o/p like the below one:

Product id	error message
1
2	a
2	b
2	c
2	d
2	e
3	b
3	a
3	c
4
5	x
5	y
5	z
6	d
6	e
6	f

JordanB

Hi @Tharashasank

You can add multiple delimiters into the delimiters box. Just add the new delimiter next to the ;

I just used ; as that was the only value in your example. 

Best,

Jordan Barker