I need to transpose rows into columns and display primary key only ones

[Akshay]

I have a data set like

             ID          Product

              1            A

              1            B

              1            C

              2            P

              2           Q

              2            R

I need it in a form like:

            ID            Col1           Col2           Col3

             1              A                 B               C

             2              P                  Q              R

Is there any possible way to implement this in PowerBI

[mehaboob557]

Hi @Akshay

Use matrix visual to achieve this.

Put the field in rows which you would like to have and another field in columns.

[Akshay]

Thanks for the reply, but I need the above structure so that I can implement Network Directed Graph. In network directed graph I think its mandatory to have only 1 transaction(row) for each ID.

Thanks in advance!!