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?