My table is like below
| ColA | ColB | ColC | ColD | ColE | ColF |
|---|---|---|---|---|---|
| ABCD | EFGH | HIJK | R111 | HIJK | 20 |
| ABCD | EFGH | XXXX | R111 | XXXX | 30 |
| ABCD | EFGH | XXXX | R112 | YYYY | 40 |
| ABCD | EFGH | zzzz | R112 | zzzz | 50 |
Output what I want is
| ColA | ColB | ColC | R111 | R112 |
|---|---|---|---|---|
| ABCD | EFGH | HIJK | 20 | |
| ABCD | EFGH | XXXX | 30 | 40 |
| ABCD | EFGH | zzzz | 50 |
I tried using SQL PIVOT, but I keep getting parameter not valid error.
Essentially ColD,ColE and ColF is what I want to transpose where ColE and ColC are same.
Can someone help ?