Forum Discussion

Noob_with_PBI's avatar
Noob_with_PBI
Regular Visitor
3 years ago
Solved

Transpose in 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.

  • Hello, do this in power query:

     

    1 Select the Geogrpahy column,

    2 Transform>>>Unpivot other columns

    3 Close and load.

     

    Cheers,

     

1 Reply

  • samdthompson's avatar
    samdthompson
    Memorable Member

    Hello, do this in power query:

     

    1 Select the Geogrpahy column,

    2 Transform>>>Unpivot other columns

    3 Close and load.

     

    Cheers,