I am trying to rearrange a data in dataiku platform. i am performing several operations, pivoting transposed the data but created more null data. as below
THE data i have
TIME | tag1 | tag2 | tag3 | tag4 | tag5 |
00:15:00 | 1 | ||||
00:15:00 | 2 | ||||
00:15:00 | 3 | ||||
00:15:00 | 4 | ||||
00:15:00 | 5 | ||||
00:30:00 | 7 | ||||
00:30:00 | 6 | ||||
00:30:00 | 8 | ||||
00:30:00 | 10 | ||||
00:30:00 | 9 |
The Data i need it to be
TIME | tag1 | tag2 | tag3 | tag4 | tag5 |
00:15:00 | 1 | 2 | 3 | 4 | 5 |
00:30:00 | 6 | 7 | 8 | 9 | 10 |