Create New field based on other fields

[ZoeM]

Alteryx Masters!

Hey real simple I bet you, in the attached how can i create a new Field which is a summary of the three Year fields? In essence, I want a a new field Year which has the available years and not as separate columns?

Thanks!

[kelsey_kincaid]

Hi @ZoeM - could you provide an example of what you're trying to do? Are you wanting to sum all three years in a separate field?

[ZoeM]

So I would like to have two fields: Model and Year.

[reply_mueller · Accepted solution]

Hello @ZoeM,

this is indeed very easy. The magic tool to achieve such tasks is the Transpose-Tool which creates a row layout from column data. Check this link to learn more.

Keying the data by Model will produce the desired result, as you can see:

[ZoeM]

Awesome!

That is what I am looking for. 

Thanks a lot!