Conditional Unpivot in powerquery

[nickzizos]

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

[v-jiascu-msft · Accepted solution]

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]

Hi @nickzizos,

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

Best Regards!

Dale