Transpose only selected columns into rows

[Anonymous]

Hi all,

I'd like some help turning my raw data into the data format desired as shown in the screenshot below. Any suggestions on how to do this? Thank you!

[amitchandak · Accepted solution]

@Anonymous 

Select these columns and do unpivot in transform data mode /edit query mode

https://radacad.com/pivot-and-unpivot-with-power-bi

** Rename columns before unpivot

[JoseAndres]

Thanks

[Anonymous]

@amitchandak thanks. How can I select multiple columns at once to unpivot? I have around 30 columns to unpivot.

[amitchandak]

Select the first column press shift and select the last column. Or with the control you should able to select one by one

[Anonymous]

@amitchandak Never mind, I got it. Thanks!