quincymondragon
New Member
- Joined
- Jun 5, 2013
- Messages
- 5
Hi all, i've got a file excel with this scheme:
[TABLE="width: 860"]
<tbody>[TR]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[/TR]
[TR]
[TD]Lat. #1[/TD]
[TD]Long. #1[/TD]
[TD]Lat. #2[/TD]
[TD]Long. #2[/TD]
[TD]Lat. #3[/TD]
[TD]Long. #3[/TD]
[TD]Lat. #4[/TD]
[TD]Long. #4[/TD]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[/TR]
[TR]
[TD]Lat. #5[/TD]
[TD]Long. #5[/TD]
[TD]Lat. #6[/TD]
[TD]Long. #6[/TD]
[TD]Lat. #7[/TD]
[TD]Long. #7[/TD]
[TD]Lat. #8[/TD]
[TD]Long. #8[/TD]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[/TR]
[TR]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
i wolud like to traspose into this:
[TABLE="width: 172"]
<tbody>[TR]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[/TR]
[TR]
[TD]Lat. #1[/TD]
[TD]Long. #1[/TD]
[/TR]
[TR]
[TD]Lat. #2[/TD]
[TD]Long. #2[/TD]
[/TR]
[TR]
[TD]Lat. #3[/TD]
[TD]Long. #3[/TD]
[/TR]
[TR]
[TD]Lat. #4[/TD]
[TD]Long. #4[/TD]
[/TR]
[TR]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[/TR]
[TR]
[TD]Lat. #5[/TD]
[TD]Long. #5[/TD]
[/TR]
[TR]
[TD]Lat. #6[/TD]
[TD]Long. #6[/TD]
[/TR]
[TR]
[TD]Lat. #7[/TD]
[TD]Long. #7[/TD]
[/TR]
[TR]
[TD]Lat. #8[/TD]
[TD]Long. #8[/TD]
[/TR]
[TR]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[/TR]
[TR]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[/TR]
</tbody>[/TABLE]
How i could do this with a macro? Someone could help me?
Thank you!!!
[TABLE="width: 860"]
<tbody>[TR]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[/TR]
[TR]
[TD]Lat. #1[/TD]
[TD]Long. #1[/TD]
[TD]Lat. #2[/TD]
[TD]Long. #2[/TD]
[TD]Lat. #3[/TD]
[TD]Long. #3[/TD]
[TD]Lat. #4[/TD]
[TD]Long. #4[/TD]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[/TR]
[TR]
[TD]Lat. #5[/TD]
[TD]Long. #5[/TD]
[TD]Lat. #6[/TD]
[TD]Long. #6[/TD]
[TD]Lat. #7[/TD]
[TD]Long. #7[/TD]
[TD]Lat. #8[/TD]
[TD]Long. #8[/TD]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[/TR]
[TR]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
i wolud like to traspose into this:
[TABLE="width: 172"]
<tbody>[TR]
[TD="width: 86"]Lat[/TD]
[TD="width: 86"]Long[/TD]
[/TR]
[TR]
[TD]Lat. #1[/TD]
[TD]Long. #1[/TD]
[/TR]
[TR]
[TD]Lat. #2[/TD]
[TD]Long. #2[/TD]
[/TR]
[TR]
[TD]Lat. #3[/TD]
[TD]Long. #3[/TD]
[/TR]
[TR]
[TD]Lat. #4[/TD]
[TD]Long. #4[/TD]
[/TR]
[TR]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[/TR]
[TR]
[TD]Lat. #5[/TD]
[TD]Long. #5[/TD]
[/TR]
[TR]
[TD]Lat. #6[/TD]
[TD]Long. #6[/TD]
[/TR]
[TR]
[TD]Lat. #7[/TD]
[TD]Long. #7[/TD]
[/TR]
[TR]
[TD]Lat. #8[/TD]
[TD]Long. #8[/TD]
[/TR]
[TR]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[/TR]
[TR]
[TD]Lat. #...[/TD]
[TD]Long. #...[/TD]
[/TR]
</tbody>[/TABLE]
How i could do this with a macro? Someone could help me?
Thank you!!!