Hope you're doing well.
Let's say I have a table looking like this:
| Date | Column | Val |
|---|---|---|
| date1 | x | 5 |
| date1 | y | 20 |
| date1 | z | 48 |
| date2 | x | 10 |
| date2 | y | 30 |
I wish to get the following table:
| Date | x | y | z |
|---|---|---|---|
| date1 | 5 | 20 | 48 |
| date2 | 10 | 30 | null |
Is it possible?
-
The keyword you're looking for is "pivot". The solution will likely be different for each DBMS, so you should remove irrelevant tags from your question.– mustaccioJun 23 at 11:27
-
BigQuery, MySQL or Postgres? Please do not tag databases not involved.– a_horse_with_no_nameJun 23 at 11:29
-
1PIVOT operator– AkinaJun 23 at 11:56
Add a comment
|