Hi - My second beginner question today. I have imported data from the left hand table below but would like to end up with the second table i.e. deselect the row for H1 2019 and rename H2 2019 as 2019, then rename Est 2020 as 2020. Whats the quickest way to do this please?
Many thanks!
| Year | Value | | Year | Value |
| 2017 | 100 | | 2017 | 100 |
| 2018 | 110 | | 2018 | 110 |
| H1 2019 | 112 | | 2019 | 115 |
| H2 2019 | 115 | | 2020 | 120 |
| Est 2020 | 120 | | | |
