I have a similar problem I’m hoping you could help with. I have data in the following format:
[TABLE="width: 184"]
<tbody>[TR]
[TD="width: 103, bgcolor: transparent"]
[/TD]
[TD="width: 143, bgcolor: transparent"]
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
John Smith
[/TD]
[TD="width: 143, bgcolor: transparent"]
111-111-1111
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
1 Any Street
[/TD]
[TD="width: 143, bgcolor: transparent"]
111-111-1112
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
Anytown, NY 11111
[/TD]
[TD="width: 143, bgcolor: transparent"]
john@anyemail.com
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
Mary Smith
[/TD]
[TD="width: 143, bgcolor: transparent"]
222-222-2222
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
2 Any Street
[/TD]
[TD="width: 143, bgcolor: transparent"]
222-222-2222
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
Anytown, NJ 22222
[/TD]
[TD="width: 143, bgcolor: transparent"]
mary@anyemail.com
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
Bob Smith
[/TD]
[TD="width: 143, bgcolor: transparent"]
333-333-3333
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
3 Any Street
[/TD]
[TD="width: 143, bgcolor: transparent"]
333-333-3333
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
Anytown, CA 33333
[/TD]
[TD="width: 143, bgcolor: transparent"]
bob@anyemail.com
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
(John Smith is in cell B3, john@anyemail.com is in cell C5)
I need to get the data in the following format of a new sheet:
[TABLE="width: 336"]
<tbody>[TR]
[TD="width: 31, bgcolor: transparent"]
[/TD]
[TD="width: 49, bgcolor: transparent"]
Name
[/TD]
[TD="width: 52, bgcolor: transparent"]
Addr1
[/TD]
[TD="width: 63, bgcolor: transparent"]
Addr2
[/TD]
[TD="width: 55, bgcolor: transparent"]
Phone1
[/TD]
[TD="width: 55, bgcolor: transparent"]
Phone2
[/TD]
[TD="width: 143, bgcolor: transparent"]
Email
[/TD]
[/TR]
[TR]
[TD="width: 31, bgcolor: transparent"][/TD]
[TD="width: 49, bgcolor: transparent"]
John Smith
[/TD]
[TD="width: 52, bgcolor: transparent"]
1 Any Street
[/TD]
[TD="width: 63, bgcolor: transparent"]
Anytown, NY 11111
[/TD]
[TD="width: 55, bgcolor: transparent"]
111-111-1111
[/TD]
[TD="width: 55, bgcolor: transparent"]
111-111-1112
[/TD]
[TD="width: 143, bgcolor: transparent"]
john@anyemail.com
[/TD]
[/TR]
[TR]
[TD="width: 31, bgcolor: transparent"][/TD]
[TD="width: 49, bgcolor: transparent"]
Mary Smith
[/TD]
[TD="width: 52, bgcolor: transparent"]
2 Any Street
[/TD]
[TD="width: 63, bgcolor: transparent"]
Anytown, NJ 22222
[/TD]
[TD="width: 55, bgcolor: transparent"]
222-222-2222
[/TD]
[TD="width: 55, bgcolor: transparent"]
222-222-2222
[/TD]
[TD="width: 143, bgcolor: transparent"]
mary@anyemail.com
[/TD]
[/TR]
[TR]
[TD="width: 31, bgcolor: transparent"][/TD]
[TD="width: 49, bgcolor: transparent"]
Bob Smith
[/TD]
[TD="width: 52, bgcolor: transparent"]
3 Any Street
[/TD]
[TD="width: 63, bgcolor: transparent"]
Anytown, CA 33333
[/TD]
[TD="width: 55, bgcolor: transparent"]
333-333-3333
[/TD]
[TD="width: 55, bgcolor: transparent"]
333-333-3333
[/TD]
[TD="width: 143, bgcolor: transparent"]
bob@anyemail.com
[/TD]
[/TR]
</tbody>[/TABLE]
(John Smith is in cell B2)
The initial data could be hundreds of rows that I’m currently manually rearranging, and as you can imagine, is very time consuming. The initial data is always broken up into sets of 3 rows and 2 columns per record. Any assistance you could provide would be greatly appreciated.