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?