Hi All,
I have a bit of a problem figuring out how to clean/transpose my source table which currently looks like this:
| Entity Name | Expense A | Expense A | Expense A | Expense B | Expense B | Expense B |
| | 2017 | 2016 | 2015 | 2017 | 2016 | 2015 |
| A | 1 | 3 | 3 | 8 | 4 | 11 |
| B | 2 | 3 | 45 | 7 | 7 | 12 |
| C | 2 | 6 | 6 | 6 | 9 | 13 |
Ideally the table I want should look something like this:
| Entity Name | Year | Expense | Value |
| A | 2017 | Expense A | XX |
| A | 2016 | Expense A | XX |
| A | 2015 | Expense A | XX |
| A | 2017 | Expense B | XX |
| A | 2016 | Expense B | XX |
| A | 2015 | Expense B | XX |
| B | 2017 | Expense A | XX |
| B | 2016 | Expense A | XX |
| B | 2015 | Expense A | XX |
| B | 2017 | Expense B | XX |
| B | 2016 | Expense B | XX |
| B | 2015 | Expense B | XX |
| C | 2017 | Expense A | XX |
| C | 2016 | Expense A | XX |
| C | 2015 | Expense A | XX |
| C | 2017 | Expense B | XX |
| C | 2016 | Expense B | XX |
| C | 2015 | Expense B | XX |
Any help with the workflow is much appreciated!!!
