Create a new Data Source from an Existing Source

[JACK__]

I currently have a data source like follows:

SKU	Site 1	Site 2	Site 3	Week
123	10	9	7	1
123	9	9	7	2
789	1	2	1	1
789	2	2	2	2

To create part of my report I figured it would be easiest if I could create a second data source from the original that is layed out differently, but I can't quite figure out if it is possible.

The end result would be:

SKU	Week	Site	Price
123	1	Site 1	10
123	1	Site 2	9
123	1	Site 3	7
123	2	Site 1	9
123	2	Site 2	9
123	2	Site 3	7
789	1	Site 1	1
789	1	Site 2	2
789	1	Site 3	1
789	2	Site 1	2
789	2	Site 2	2
789	2	Site 3	2

Any Ideas?

[Arul · Accepted solution]

@JACK__ ,

Go to Power Query Editor and select all the 3 site columns of the table you wanted to modify. Then, select unpivot columns (highlighted in the image),

your resulted table should be like this, and then you can rename the value column as price,

[JACK__]

Thank You 🙏