I am trying to transpose the column data into rows ...Is it possible ?
ID | Values |
---|---|
ID111 | P11 |
ID111 | P12 |
ID222 | P21 |
ID222 | P22 |
So i want the above data like...
ID | Col1 | Col2 | |
---|---|---|---|
ID111 | P11 | P12 | |
ID222 |
| P22 |
Which activity i need to use or do i need to write the java script code?