Forum Discussion

nickzizos's avatar
nickzizos
Frequent Visitor
9 years ago
Solved

Conditional Unpivot in powerquery

In power query I would like to unpivot my table based on a condition: unpivot all columns except those that start with "IP_address" or "Please state your".

Is this possible?

 

Thank you

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi nickzizos,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

     

    Best Regards!
    Dale

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi nickzizos,

     

    We can select these columns with "Ctrl", then use "Unpivot other columns". Please have a try.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi nickzizos,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

     

    Best Regards!
    Dale