Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Apply single row to a new column

Highlighted
6 - Meteoroid

Can anyone suggest ways of converting the table below to the output shown? Thanks 

 

 2016201720182019
Company NameReported Cash Flow ($M)Reported Cash Flow ($M)Reported Cash Flow ($M)Reported Cash Flow ($M)
XYZ300344355366
ABX156180210220
CVD233255270290
FFG165180190240

 

Company NameYearReported Cash Flow ($M)
XYZ2016300
ABX2016156
CVD2016233
FFG2016165
XYZ2017344
ABX2017180
CVD2017255
FFG2017180
XYZ2018355
ABX2018210
CVD2018270
FFG2018190
XYZ2019366
ABX2019220
CVD2019290
FFG2019240

 

 

Highlighted
11 - Bolide

Hi @MROGK ,

This is a great use case for the Transpose tool. An example workflow is attached and shown below.

 

kayers_0-1580327916548.png

Labels