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 |
Solved! Go to Solution.
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,
Thank you @Thableaus
This worked like a charm. 🙂