Forum Discussion
Solved
Unpivot Multiple Columns - Desktop
**total noob alert* Is there a to unpivot multiple data in PBI desktop? I have datasource = Excel which is has an unusable data structure. Table headers are shown transposed below: Im looki...
Hi bigdee008
Please check all the applied steps in Query Editor.The last step fill down can be used for other columns you need.
Regards,
Cherie
Hi bigdee008
You may add condition column and index column.Then use 'Pivot column'.Attached the sample file for your reference.
Regards,
Cherie
Hello v-cherch-msft Thanks for the effort but to say that I understand what your are suggesting, i would be lying. Again i have to wwarn that I am a complete noob. Can you share a little bit more detail?