Forum Discussion

MGorak's avatar
MGorak
Frequent Visitor
3 years ago
Solved

Transform coulumns to rows with cell values

Hello everyone

I'm pleasure to be here first time.

I have problem with transforming call off file to be accetable by Power BI.

 

Root querry is below:

 

Could somebody help me to change to table below with 3 coulumns: Data from first coulumn i raw file, Item from Coulumns name (about 240 coulumns), Quantity: number of exact cell refer to data and item

 

Thank You very much in advance

2 Replies

  • AntrikshSharma's avatar
    AntrikshSharma
    Icon for Community Champion rankCommunity Champion

    MGorak Right click on the Item Column and choose the optinon "Unpivot other columns"

    • MGorak's avatar
      MGorak
      Frequent Visitor

      Great, it works. Thank You