merge two columns of one table in a new table

[FalkoKoehler]

Hi All,

i am looking for a way to merge two columns of one table in a new table for the following example:

Table:

ID     Employees Dpt1     Employees Dpt2

543        12                                 11

323         4                                  22

New table should be:

ID          Dpt         Employees

543       Dpt1              12

543       Dpt2              11

323       Dpt1              4

323       Dpt2              22

Thanks a lot for your help :)!

Regards

[Abduvali]

Hi @FalkoKoehler,

You need to use Unpivot function in power bi edit query mode:

Highlight two columns and click right button on your mouse, and select Unpivot columnsResult

Regards

Abduvali

[FalkoKoehler]

Hi @Abduvali,

thanks for your reply. My source table needs to hav unique IDs so I cannot unpivot directly in the source table. So what i did is to create a new table with the summarize function (only leaving the relevant columns). The problem now is that the query moder is only available for imported/connected tables but not when they are created inside Power BI it seems - so i cannot find a way to unpivot this? 😞

Do you got a solution for this?

[Abduvali · Accepted solution]

Go back to Edit mode and instead of using Summarize try using Duplicate Table and perform all transformations within that duplicate table. 

That might do the trick for you.

[FalkoKoehler]

@Abduvaliyou were too fast i was just about to declare it as resolved as i got exactly you solution a second ago 😄

[Abduvali]

@FalkoKoehler well-done mate!