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

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