Forum Discussion
Transpose only selected columns into rows
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!
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
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
amitchandak thanks. How can I select multiple columns at once to unpivot? I have around 30 columns to unpivot.
amitchandak Never mind, I got it. Thanks!
Select the first column press shift and select the last column. Or with the control you should able to select one by one
Thanks
