I would like to a cell value into rows, and also duplicate the rest of the columns

[Manjari]

Hi All, 

Requesting help 🙂

I would like to a cell value into rows, and also duplicate the rest of the columns

I have a data set like the below, 

Data	Dessert 1	Dessert 2	Snack
#B;#117;#C;#120;#D;#123;#E;#36	Chocolate	Ice cream	Muffin

I would like the output to be like the below 

Data	Dessert 1	Dessert 2	Snack
B	Chocolate	Ice cream	Muffin
C	Chocolate	Ice cream	Muffin
D	Chocolate	Ice cream	Muffin
E	Chocolate	Ice cream	Muffin

[Thableaus]

Hi @Manjari 

Use the Text to Columns tool with the option to Split to Rows (and delmiter = 😉

Then clean your dataset with the way you want.

Cheers,

[Thableaus · Accepted solution]

@Manjari 

Here's a worklow to do it (attached)

Cheers,

[Manjari]

Thank you @Thableaus 

This worked like a charm. 🙂