Apply single row to a new column

[MROGK]

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

	2016	2017	2018	2019
Company Name	Reported Cash Flow ($M)	Reported Cash Flow ($M)	Reported Cash Flow ($M)	Reported Cash Flow ($M)
XYZ	300	344	355	366
ABX	156	180	210	220
CVD	233	255	270	290
FFG	165	180	190	240

Company Name	Year	Reported Cash Flow ($M)
XYZ	2016	300
ABX	2016	156
CVD	2016	233
FFG	2016	165
XYZ	2017	344
ABX	2017	180
CVD	2017	255
FFG	2017	180
XYZ	2018	355
ABX	2018	210
CVD	2018	270
FFG	2018	190
XYZ	2019	366
ABX	2019	220
CVD	2019	290
FFG	2019	240

[kelsey_kincaid · Accepted solution]

Hi @MROGK ,

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