Create table from values in another columns

[Anonymous]

Hi,

I have a requirement where we want to create table and columns based on the values in another column as explained below:-

Table1:-

ProjectName Col1      ValueForCol

Prjct1             R1C1       P1R1C1

Prjct1             R2C1       P1R2C1

Prjct2             R3C1       P2R3C1

Prjct2             R4C1       P2R4C1

Can someone help on this?

We want to create table as below:-

ProjectName  R1C1       R2C1       R3C1       R4C1

Prjct1              P1R1C1  P1R2C1    Null        Null

Prjct2              Null        Null          P2R3C1  P2R4C1

[Zubair_Muhammad · Accepted solution]

@Anonymous

Using Query Editor you can pivot Col1 using ValueForCol as "Values"

In the advanced options select "Dont Summarize"

[Anonymous]

Thanks a lot! It worked!!

But if we want to have pivot based on two columns value then do we have that option in Pivot?