Transposing row to columns - with multiple columns belonging to 1 new column

Deron__

Dear community,

I have the following situation and I have not found any solution to this yet.

I currently have the following table:

And after the Alteryx workflow I would like to have the following table:

Does anyone know how to create the workflow for this? Thank you very much!!

Datasets

Input

Best Practices

Help

Join

Accepted answers

philipmannering

Hey @Deron__ . No problem.

So the fields do indeed get renamed when you import the spreadsheet.

See attached a very similar solution to before. I've used the Tile Tool and Dynamic Rename to keep the columns headers as they should be (otherwise punctuation and spaces get converted to underscores). Take a look at the attached...I think it works (you may need to reconnect the input file).

Transpose table 2.yxmd

Deron__

Hi Philip,

Thank you - it seems to work indeed! Would the below solution be a simpler version of what you created or are there any downsides to this? See attached.

Alteryx Community Solution simplified.yxmd

All comments

philipmannering

Hi @Deron__

Does this work?

Transpose table.yxmd

grazitti_sapna

Hi @Deron__ ,

Please find attached the screenshot and Workflow for your reference. I hope it helps.

Screenshot_7.png

Transpose.yxmd

Deron__

Thank you for your prompt reply!

Sorry, I believe I had to write the table differently. The product columns are not necessarily unique (so not necessarily type 1, type 2 and type 3 etc in the columns). Rather this is how I could have my dataset (see below). As you can see there is no unique ID for each column, the columns could be exacty the same (so every record is Type 1, every record has discount rate of 1.0% and every record as years of 10), which is not a problem for the purpose of my analysis but all I want is that the product, discount and years old are the column names and everything else falls under that. See below what I mean:

And it should become:

Thank you so much!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703