Forum Discussion
Solved
Need help in pivot unpivot the data
I have an excel data like below
| id | value | text |
| U1 | abc | North |
| U1 | fgh | Up |
| U1 | jse | In |
| U2 | abc | South |
| U2 | fgh | Down |
| U2 | jse | Out |
| U2 | fjg | 1 |
| U2 | qwo | 2 |
which need to be converted to the below i tried unpivot and pivot too but couldnt get it. pls help
| id | abc | fgh | jse | fjg | qwo |
| U1 | North | Up | In | ||
| U2 | South | Down | Out | 1 | 2 |
Hi,
See this screenshot
1 Reply
- Ashish_Mathur
Super User
Hi,
See this screenshot