help query

[Anonymous]

Hello, stupid question mabe. But I want to pass this table: 

To this form:

Res1   enfant   0.2

Res1   adulte   0.8

Res2   enfant   0.3

Res2   adulte   0.7

And it looks I can't do it with unpivot columns...

[Anonymous · Accepted solution]

I tried with unpivot, transpose ... Thank you for your help!

[Anonymous]

Hi @Anonymous ,

Does that make sense? If so, kindly mark your answer as the solution to close the case please. Thanks in advance.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.