From row to column - crosstab

[stephi]

Hello!

I’ve got a table like this

and would like to create a crosstab with the following result:

Is this possible somehow? I’m working with postgresql.

Thank you!

[brianliston]

Hey there, did you ever figure this out?