Hi everybody,
I have one block of 10 columns. The 10 columns contain data ordered by year (from the most recent to the oldest - 2019 - 2018 .... - 2010).
Example of block of 10 columns:
<tbody>
</tbody>
What i need is to find the most recent "value for each company" and visualized in the last column.
Thanks for the help!
Amanda
I have one block of 10 columns. The 10 columns contain data ordered by year (from the most recent to the oldest - 2019 - 2018 .... - 2010).
Example of block of 10 columns:
company | A 2019 | A 2018 | A 2017 | A 2016 | A 2015 | A 2014 | A 2013 | A 2012 | A 2011 | A 2010 | value for company |
X | 52 | 23 | 256 | 52 | |||||||
Y | 111 | 111 | |||||||||
Z | 12 | 12 |
<tbody>
</tbody>
What i need is to find the most recent "value for each company" and visualized in the last column.
Thanks for the help!
Amanda