join columns but pick specific content based on other column

[df]

Hi,

3 columns with average revenue of year 2015, 2016 & 2017.

now i want to combine those columns into one.

But the content of the new column must match the year.

if year is 2015 pick content from column "average revenue 2015" and so on.

Is there a way to do this? (attached both tables)

[LordNeilLord · Accepted solution]

Hey @df,

This should work for you:

• Transpose the years
• Parse out the Year from the new column
• Summarize by year..taking the first amount (avg, min or max will do the same)