Transpose Excel Table Issue

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:

Screen Shot 2020-04-16 at 7.16.58 AM.png

Expected outcome:

Screen Shot 2020-04-16 at 7.17.37 AM.png

Transpose Issue.xlsx

Datasets

Transformation

Accepted answers

Aaron_Harter

Hi @Chalsea,

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

2020-04-16 transpose.yxmd

All comments

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

Hi @Chalsea,

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

2020-04-16 transpose.yxmd

Chalsea

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703