Forum Discussion
MGorak
3 years agoFrequent Visitor
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
MGorak Right click on the Item Column and choose the optinon "Unpivot other columns"
2 Replies
- AntrikshSharma
Community Champion
MGorak Right click on the Item Column and choose the optinon "Unpivot other columns"
- MGorakFrequent Visitor
Great, it works. Thank You