Forum Discussion
Solved
Pivoting Multiple Columns More Efficiently
Hi, I am trying to find a more efficient way to multiple pivot columns in Power Query from a shipping report. I'm currently selecting each pair of columns (description and adjacent amount), pivoting ...
Hi Andrew415 ,
With your source data, I came up with a solution in Power Query. Do have a look. Thanks!
https://docs.google.com/spreadsheets/d/1EIpZo5-DOpKhDYU4IMOfQYYtWdMh6sx7/export?format=xlsx&ouid=104752674875039603034&rtpof=true&sd=true
hello Andrew415
i dont know how many column you want to show in your visual.
if your visual only contain couple columns such as Extended Residential, Fuel Surcharge, Remote Residential, and Address Correction, maybe measure should be sufficient for those four instead of unpivoting ~100 columns.
Hope this will help.
Thank you.