How to unstack these data?
I was given these data below, and asked the following question. How would I go about it?
B) From the below table, analyze, interpret and show the performance and trend within 3 years using the following secondary data of Women and girl traders’ annual income:
Table 1 : Performance indicators in thousands RWF
DistrictIncome Year 1Income Year2Income Year 3DistrictIncome Year 1Income Year2Income Year 3Baseline 2021Target2021ResultsBaseline FY 2022Target 2022ResultsBaseline FY 2023Target 2023ResultsBurera District23578067567580071071012301230Gakenke District22663069069011001100110014001400Gicumbi District120560380380640747747904904Musanze District41180170070091098098013201320Rulindo District117440440440700690690900900
Below is a sample screenshot of what I came up with (I used power query). Is this correct?
It is NOT analizable. that's why I am asking for help.
What should I do to make that data analyzable in pivot table?
I appreciate any help from you !