Forum Discussion
Solved
Equivalent behavior to Switch Rows-Columns in Excel
Below is an example of a table of data which I've been asked to put into a visual: Month_Year AggPct1 AggPct2 AggPct3 AggPct4 AggPct5 AggPct6 Jan-21 24.06 29.8 32.86 34.81 36.11 ...
I think if you went into power query.
Selected your Month_Year column and then on the transform tab clicked unpivot other columns. You should then find it easier to build the graph you want.
Thank you - I had played around with pivot/unpivot but never got it quite right. This turned out like what was desired, and I can tweak from here... had to figure out axis, legend, values on the line chart after unpivot. Your help was much appreciated as this might save me from having to do manual work in Excel every month!