Hi Everyone,
I need to achieve this in load script using CrossTable function. Not sure if this can be done for the below scenario
my sample dataset looks like this -
| Id | Name | Title | Value |
| 1 | TMO | Sent | Yes |
| 1 | TMO | Status | Transit |
| 1 | TMO | Days Taken | 3 |
| 2 | PRO | Sent | No |
| 2 | PRO | Status | Dispatched |
| 2 | PRO | Days Taken | 5 |
Now I need to achieve into this -
| ID | Name | Sent | Status | Days Taken |
| 1 | TMO | Yes | Transit | 3 |
| 2 | PRO | No | Dispatched | 5 |
How do i get this with Cross Table or is there any other way to get the above output.
Kindly assist me here!
Thanks in advance!!!!
