I have copy and pasted a HTM file into Excel. The headers and information is stacked onto two lines on the original report. I need the headers to be separated onto one line and the two lines of information to follow the header it is attached to. example below. the yellow below should follow the yellow title above and the tan follow the tan. I have several columns of this going one. I hope this makes sense. Any suggestions would be greatly appreciated. Thanks.
[TABLE="width: 257"]
<colgroup><col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;"> <col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <tbody>[TR]
[TD="class: xl67, width: 63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "]MRN[/TD]
[TD="class: xl67, width: 83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "]Age/Sex[/TD]
[TD="class: xl67, width: 111, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "]Checkin Date[/TD]
[TD="class: xl67, width: 87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "]Arrival Mode[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow"]FIN[/TD]
[TD="class: xl66, bgcolor: yellow"]Birth Date[/TD]
[TD="class: xl66, bgcolor: yellow"]Checkout Date[/TD]
[TD="class: xl66, bgcolor: yellow"]Acuity[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] , align: right"]80017482[/TD]
[TD="class: xl67, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "]24 Y/Female[/TD]
[TD="class: xl68, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] , align: right"]11/19/2017 0:19[/TD]
[TD="class: xl67, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "] Self[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow, align: right"]70044427[/TD]
[TD="class: xl69, bgcolor: yellow, align: right"]3/23/1993[/TD]
[TD="class: xl65, bgcolor: yellow, align: right"]11/19/2017 13:10[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 257"]
<colgroup><col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;"> <col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <tbody>[TR]
[TD="class: xl67, width: 63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "]MRN[/TD]
[TD="class: xl67, width: 83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "]Age/Sex[/TD]
[TD="class: xl67, width: 111, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "]Checkin Date[/TD]
[TD="class: xl67, width: 87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "]Arrival Mode[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow"]FIN[/TD]
[TD="class: xl66, bgcolor: yellow"]Birth Date[/TD]
[TD="class: xl66, bgcolor: yellow"]Checkout Date[/TD]
[TD="class: xl66, bgcolor: yellow"]Acuity[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] , align: right"]80017482[/TD]
[TD="class: xl67, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "]24 Y/Female[/TD]
[TD="class: xl68, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] , align: right"]11/19/2017 0:19[/TD]
[TD="class: xl67, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE4D6]#FCE4D6[/URL] "] Self[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow, align: right"]70044427[/TD]
[TD="class: xl69, bgcolor: yellow, align: right"]3/23/1993[/TD]
[TD="class: xl65, bgcolor: yellow, align: right"]11/19/2017 13:10[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]