I have the table as below
| EMPID | MESASURE | | MEASURE_VAL1 |MEASURE_VAL2 |MEASURE_VAL3 |
| -------- | -------------- |---------- |-------------- |--------------
| A | MEASURE1 | 10 | NULL | NULL
| A | MEASURE2 | NULL | 20 | NULL
| A | MEASURE3 | NULL | NULL | 30
| A | MEASURE4 | NULL | NULL | NULL
I want to get the result as
| EMPID | MEASURE 1 | MEASURE 2 | MEASURE 3
-------------------------------------------
| A | 10 | 20 | 30
I tried with where not null and get only one value. Please suggest. Thanks