Hello- Could I please get help with this? Input FoodItem NumberFood 1Food 2Food 3Item Number 1Item Number 2Item Number 3Fries, Pasta, Bread52, 53, 58FriesPastaBread525358 Desired output FoodItem NumberFries52Pasta53Bread58

Datasets

Hello- Could I please get help with this?

Input

Food	Item Number	Food 1	Food 2	Food 3	Item Number 1	Item Number 2	Item Number 3
Fries, Pasta, Bread	52, 53, 58	Fries	Pasta	Bread	52	53	58

Desired output

Datasets

Here is one way to do this:

My solution uses the Transpose and multi row formula tools check out the community videos here if your not famulure with the tools:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Here is one way to do this:

My solution uses the Transpose and multi row formula tools check out the community videos here if your not famulure with the tools:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

This was an interesting one and not sure if I've gone totally long-winded but here's what I came up with:

Hi @CarolyneG , Just an another solution recommendation without using Regex or Text to Columns tool. Please accept my solution if you like it.

Thanks!!

Thank you.

solution Attached