Change selected columns to rows keeping columns A and B the same

[Pandadev]

I have a database of values where each linked id is in a new column , id1 , id2 , id3 - id151

I want to keep column A - Type and Column B Org the same.

Example

Type - Org             id1      id2     id3      id4

A         AAA            22       26      28       29

B         BBB             26       29      42       44

I want it show as 

Type    Org        ID

A        AAA        22

A        AAA       26

A        AAA       28

A        AAA       29

B        BBB        26

B        BBB        29

B        BBB        42

B        BBB        44

Is this possible in PowerBI , please

[az38]

Hi @Pandadev 

go to the Power QUery, select Type and Org columns, right-click,  Unpivot other columns and rename column Value to ID

[Pandadev · Accepted solution]

Thanks for your quick response , that worked great .