SanketDash
New Member
- Joined
- Apr 14, 2015
- Messages
- 4
I need help in transposing data from rows to columns. Currently, my data is looking like this:
<tbody>
</tbody>
I want my data to look like this
<tbody>
</tbody>
I have mentioned the same numbers in each row for convenience purpose ony. In the actual data-set, the rows have different values.
Y1 | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
Y2 | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
Y3 | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
Y4 | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
<tbody>
</tbody>
I want my data to look like this
Y1 | 1 | 2 | 3 | 4 |
Y2 | 1 | 2 | 3 | 4 |
Y3 | 1 | 2 | 3 | 4 |
Y4 | 1 | 2 | 3 | 4 |
Y1 | 6 | 7 | 8 | 9 |
Y2 | 6 | 7 | 8 | 9 |
Y3 | 6 | 7 | 8 | 9 |
Y4 | 6 | 7 | 8 | 9 |
Y1 | 10 | 11 | 12 | 13 |
Y2 | 10 | 11 | 12 | 13 |
Y3 | 10 | 11 | 12 | 13 |
Y4 | 10 | 11 | 12 | 13 |
<tbody>
</tbody>
I have mentioned the same numbers in each row for convenience purpose ony. In the actual data-set, the rows have different values.