How to inverse column and row in Redshift?

How can I inverse my data in Redshift from

user_id	type1	type2
1	true	false
2	true	false

to

user_id	type	value
1	type1	true
1	type2	false
2	type1	true
2	type2	false

https://stackoverflow.com/questions/66898285/how-to-inverse-column-and-row-in-redshift April 01, 2021 at 12:06PM