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 · Accepted solution]

Hi @pohrt 

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

[Qiu · Accepted solution]

@pohrt 
Just a quick sample with same idea of @T_Willins 

[pohrt]

OMG that simple .... THANK YOU so much.

(never used that option)

[Qiu]

@pohrt 
We all have been there.
Soon you will be an expert.😁