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 |
Solved! Go to Solution.
Hi @MROGK ,
This is a great use case for the Transpose tool. An example workflow is attached and shown below.