How to unstack these data?

Ignace Girukubonye 0 Reputation points

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.

 User's image What should I do to make that data analyzable in pivot table?

I appreciate any help from you !





SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,067 questions
{count} votes