I need some direction on how to achieve the following outcome.
I've used 11g pivot before with values that suited the (mandatory) aggrigate function, but I can't see a solution for this. Any help appreciated.
|John||Project_A|| || || |
|John||Project_B|| || || |
|Steve|| ||Project_A|| || |
|Steve|| ||Project_B|| || |