Forum Discussion

Kees's avatar
Kees
Icon for Helper I rankHelper I
3 years ago
Solved

Pivoting from column to row

Hi    I'm kind of and Power BI new bee and not sure if what I want is (for me) possible to achive. I've checked the forum and possibly found some simular question thought I could not make a loaf of...
Need Help
Show and Tell
  • Migasuke's avatar
    Migasuke
    3 years ago

    Hi Kees ,

    This can be achieved quite well.
    Just use unpivoting in Power Query.

    1. Select columns with hours:

    2. Go to transform pane and click on unpivot:

    3. This will be your outcome:


    Ofcourse you just rename your columns accordingly.

     

Migasuke's avatar
Migasuke
Icon for Memorable Member rankMemorable Member
3 years ago

In case you need to keep information from more columns, which are not mentioned above, you should still be fine if you just unpivot numeric values (hours).

I am not sure what you mean by this?

Perhaps I need to have a sychonized and separate table a selection of columns in it, and then do the unpovit. Will that then give me a new/separate unpivoted target table. that I can use? . .... again not sure if that is possible,,



If you can, please provide some screenshot or dummy data, might be very helpful.

 

Kees's avatar
Kees
Icon for Helper I rankHelper I
3 years ago

Hi Migasuke,

 

Had a closed look today and seen that it brought me the solution I need!

 

Thanks and appriciate your patience.

 

Brgds Kees