New Rows after splitting up Cell Content

pohrt

Hello all,

I have create a simple example of what I want to do:

1) this is the table I have

Name	Gender	Age	Food
John	Male	23	APPLE#BREAD#COKE#ORANGE
Mary	Female	45	JUICE#SAUSAGE

2) I want to copy the rows based on the FOOD items (one food item in each row along with the other data in that Excel)

This is the result that I need

Name	Gender	Age	Food
John	Male	23	APPLE
John	Male	23	BREAD
John	Male	23	COKE
John	Male	23	ORANGE
Mary	Female	45	JUICE
Mary	Female	45	SAUSAGE

I tried a few things ("text to columns" then played around with "Multi-Row formula" and "Generate Rows" ... cannot be so hard but I am struggling ....

Thanks already,

Petra

T_Willins

Hi @pohrt 

You are on the right track with the Text to Columns tool.  After setting your delimiter use the Split to rows button.