Convert selected columns based on delimiters into rows

[ArnabSengupta]

Hi All,

I have have a dataset as follows:

SL NO.	Date	Product
12	16-Nov	W46
13	17-Nov	ED76 // W5//W46
14	18-Nov	EF455

I want convert the product specific columns into rows using the delimiter :

Output:

SL NO	Date	Product
12	16-Nov	W46
13	17-Nov	ED76
13	17-Nov	W5
13	17-Nov	W46
14	18-Nov	EF455

Help is much appreciated.

Thank you!

[Aaron_Harter · Accepted solution]

Hi @ArnabSengupta, 

Check out the 'split to rows' functionality of the Text to Columns tool: