Transpose in PBI

[Noob_with_PBI]

Hello,

Not sure if this is possible.. But i have a table with stores in rows and products in column, and each row below the product would show sales for the stores that are in rows. I wanted to insert each product from the columns into a single column, so the store would duplicate to multiple rows (1 per product) and the product sales would show on next column. See example:

FROM THIS

TO THIS

So in the example, it shows "STORE 1" being duplicated to accommodate the products that went from columns into the rows. If needed i can send the detailed file.

[samdthompson · Accepted solution]

Hello, do this in power query:

1 Select the Geogrpahy column,

2 Transform>>>Unpivot other columns

3 Close and load.

Cheers,