Forum Discussion

Tomhayw's avatar
Tomhayw
Icon for Helper I rankHelper I
4 years ago
Solved

How to pivot columns round an identifying column

Hello guys, I'm not quite sure what the technical name is for this type of modification but I've attached screenshots below to show what my query looks like compared to what I want it to look like: ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    This is called unpivoting.

    Select your first 3 columns and do Unpivot on other columns (not selected columns)

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

This is called unpivoting.

Select your first 3 columns and do Unpivot on other columns (not selected columns)

  • Tomhayw's avatar
    Tomhayw
    Icon for Helper I rankHelper I
    4 years ago

    Thank you, worked perfectly.