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?