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)

KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Icon for Impactful Individual rankImpactful Individual
4 years ago

Hi Tomhayw ,

 

Steps:

1. Add a Custom Column:  List.RemoveFirstN(List.RemoveNulls(Record.ToList(_)),3)

2. Expand column to new rows

3. Delete unwanted column

 

Regards

KT