Transpose Excel Table Issue

[Chalsea]

Hi there,

I'm pretty new to the tool and would like to get some help!

I have an excel table looks like this (see attached file) and I want to turn them into the expected format. Can someone share their best approach to tackle this? 

Thanks so much in advance!

Original table:

Expected outcome:

[AshleyL]

Hi!

You can use the transpose tool and have the key column set as the fruits field:

Once you transpose your data, you can then use a Select Tool to rename and reorder the fields how you want!

Hope this helps!

Ashley

[Aaron_Harter · Accepted solution]

Hi @Chalsea, 

You can Transpose the data from wide to tall, then use a Select tool to rename and reorder the fields:

 

[Chalsea]

Thank you so much Aaron! It worked. Much appreciated. 🙂