Datasets

[CarolyneG]

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

Food	Item Number
Fries	52
Pasta	53
Bread	58

[IraWatt · Accepted solution]

Hey @CarolyneG,

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: 

Multi-Row-Formula Tool: https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

Transpose tool: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[DataNath]

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

[grazitti_sapna]

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

Thanks!!

[CarolyneG]

Thank you.

[deansrd44]

solution Attached