Hi I am trying to convert the following data from a column into a row
Example
<tbody>
</tbody>
End Result to look like this:
<tbody>
</tbody>
I have hundreds of these rows and columns and I cant think of a way to do it easy.
PLEASE HELP!
Example
People | Area |
20 | 449 |
20 | 787 |
20 | 875 |
20 | 3555 |
20 | 3711 |
20 | 3760 |
20 | 4382 |
20 | 4558 |
20 | 4866 |
20 | 6344 |
20 | 6506 |
20 | 7218 |
21 | 621 |
21 | 723 |
21 | 2117 |
21 | 2229 |
21 | 4751 |
21 | 5029 |
21 | 5223 |
21 | 5421 |
21 | 5433 |
21 | 5752 |
21 | 5753 |
21 | 5773 |
21 | 6431 |
21 | 6532 |
21 | 6634 |
<tbody>
</tbody>
End Result to look like this:
20 | 21 |
449 | 621 |
787 | 723 |
875 | 2117 |
3555 | 2229 |
3711 | 4751 |
3760 | 5029 |
4382 | 5223 |
4558 | 5421 |
4866 | 5433 |
6344 | 5752 |
6506 | 5753 |
7218 | 5773 |
6431 | |
6532 | |
6634 |
<tbody>
</tbody>
I have hundreds of these rows and columns and I cant think of a way to do it easy.
PLEASE HELP!