How to combine two rows into one in excel

J

jschoen

New Member
Joined
Aug 9, 2011
Messages
1
I have the following data:

<TABLE style="WIDTH: 498pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=663><COLGROUP><COL style="WIDTH: 152pt; mso-width-source: userset; mso-width-alt: 6464" width=202><COL style="WIDTH: 135pt; mso-width-source: userset; mso-width-alt: 5760" width=180><COL style="WIDTH: 113pt; mso-width-source: userset; mso-width-alt: 4832" width=151><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4160" width=130><TBODY><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 152pt; HEIGHT: 25.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 height=34 width=202><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></v:path><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="Z-INDEX: 1; POSITION: absolute; MARGIN-TOP: 24.75pt; WIDTH: 10.5pt; HEIGHT: 10.5pt; VISIBILITY: visible; MARGIN-LEFT: 0px" id=Picture_x0020_4 o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW
nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE
APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N
bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9
Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/
8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj
39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB
BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ
TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA
ACEAU3obMesBAABXBAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWykVNtu2zAM
fR+wfxD0vtoJumEz6hRDunYDui3Y5QMYmY6FyZJAKU7696MsJw0CbAXaN4qkjg4PSV1d73sjBqSg
na3l7KKUAq1yjbabWv7+dfvmvRQhgm3AOIu1fMAgrxevX11BtSHwnVaCEWyooJZdjL4qiqA67CFc
OI+WY62jHiIfaVM0BDtG7k0xL8t3RQ/aysUj1A1EEFvSz4AyTv3BZgl2gMCQRlWnnomjUS9HhsoO
d+R/+hUl5urbsCKhm1qychZ6lkgWU2BK42NxdmvzCLBvqU/5rm3FfkR54D68nV+WZZmRcB+F4tBs
Pvsw51dUSsh2fqn7/s+7qvv039tMLBNg44SU1ypxssNKq/M6Z+WcZyKXyuG4JRSXUjQYFNVyCcSz
A0Z8RjCxO2pxBGLoe+5VENYtO7Ab/Bg8qsglMejBReR2HUITkjvrl4TOZEYxj3hro/2tNibxTfbU
aqby9Diy5lrhjVPbHm3MM0loIPIyhE77IAVV2K+R20tfGmaoeBci99iTtjEXF0j94ALGVoRIGFWX
uLTMafIz4WOA7VPGgcdIrHdfXcOgsI1uXIeXzgQ/coDwFOIdul4kg6tgpuMTMNyHxJlTDyljx13S
MvsTt5yQpqE4W6kxMn0BaW9Pz4u/AAAA//8DAFBLAwQUAAYACAAAACEAU1KJYdIAAACrAQAAKgAA
AGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc6yQwUoEMQyG74LvUHK3
mdmDiGxnLyLsVdYHCG2mU5ympa3ivr3VvTiw4MVLIAn58vHvD59xVR9cakhiYNQDKBabXBBv4PX0
fPcAqjYSR2sSNnDmCofp9mb/wiu1flSXkKvqFKkGltbyI2K1C0eqOmWWvplTidR6Wzxmsm/kGXfD
cI/lNwOmDVMdnYFydDtQp3Pun/9mp3kOlp+SfY8s7coLbN2LO5CK52ZA68vkUkfdXQGva4z/qRFi
j2CjEdkFwp/5qLP4bw3cRDx9AQAA//8DAFBLAwQUAAYACAAAACEAi2YtaLwGAADpGwAAGgAAAGNs
aXBib2FyZC90aGVtZS90aGVtZTEueG1s7FlPbxw1FL8j8R2subfZ/81G3VTZzW4Lbdoo2Rb16J3x
zrjxjEe2N+neUHtEQkIUxAWJGwcEVGolLuXTBIqgSP0KPNszs+PsLElKBAKaQ3bmzc/v+f31s331
2sOYoUMiJOVJz6tfrnmIJD4PaBL2vLvj0aV1D0mFkwAznpCeNyfSu7b57jtX8YbPaDrhWATjiMQE
AaNEbuCeFymVbqytSR/IWF7mKUng25SLGCt4FeFaIPARCIjZWqNW66zFmCbeJnBUmtGQwb9ESU3w
mdjXbAhKcAzS70yn1CcGGxzUNULO5YAJdIhZzwOeAT8ak4fKQwxLBR96Xs38eWubV9fwRjaIqRVj
S+NG5i8blw0IDhpGpggnhdD6qNW9sl3wNwCmlnHD4XAwrBf8DAD7Pmhq51Lm2Rqt1/s5zxLIPi7z
HtTatZaLL/FvLs252+/3291sLpapAdnH1hJ+vdZpbTUcvAFZfHsJ3+pvDQYdB29AFt9Zwo+udDst
F29AEaPJwRJaO3Q0yrgXkClnNyrh6wBfr2XwBQqioYguLWLKE7Uq1mL8gIsRADSQYUUTpOYpmWIf
YnKA44mgWAvAGwSXvliSL5dIWhaSvqCp6nnvpzjxSpDXL759/eIZev3i6fGj58ePfjh+/Pj40feW
lzPwBk7C8sBXX3/y+5cfot+effXqyWfVeFnG//zdRz/9+Gk1EDJooeHLz5/+8vzpyy8+/vWbJxXw
LYEnZfiYxkSi2+QI7fEYdDOGcWdOJuJ8I8YRps4IHAHvCtZDFTnA23PMqnB94hrvnoDiUQW8Pnvg
zHU/EjNFKyTfjGIHuMM563NRaYCbWlbJwuNZElYLF7Mybg/jwyrZA5w4rh3OUqiaeVA6th9ExJnm
LsOJwiFJiEL6Gz8gpEK7+5Q6dt2hvuCSTxW6T1Ef00qTjOnECaTFoBs0Br/Mq3QGVzu22bmH+pxV
ab1NDl0kJARmFZMfE+aY8TqeKRxXsRzjmJUNfgurqGqS+3Phl3FDqcDTIWEcDQMiZdWYOwL0LTn9
JoZ6Ven2HTaPXaRQ9KCK5y3MeRm5zQ8GEY7TKuw+TaIy9j15ACGK0S5XVfAd7maIfgc/4GSlu+9R
4rj79EJwl4bOlBYBor/MhPYlFGqn/sY0+bNizChUYxsDb4txz9uCpakqJW6cKMGrcP/CwruNZ8ku
gVhfXnje1t23ddf7z9fdVbl81mq7KLBQe3XzYPti0yXHK5vkKWVsX80ZuSVNnyxhsQhGQNTjzGaQ
FJumNILHrLg7uFBgMwYJrj6gKtqPcAo9dt3TTEKZsQ4lSrmEvZ0hV/LWeOjTld0ZtvWewdYDidUO
Dyy5qcn51qBgY5ac0Ow/c0FNzeCswppXMqag9psIq+tJnVla3UzNlDpHWqEy+HBZNSAW1oQuBEHv
AlbuwHZci4a9CWYk0Ha3C3DuFuOFi3SRjHBAMh9pvZd9VDdOymPFHAZA7FT4SO/zTrFaSVpXs/0L
0s7ipLK41gpxuff+ipfyCF54SeftiXRkSTk5WYKOel633Wh7yMdpz5vCthYe4xS8LnXjh1kIB0K+
EjbsT01mk+ULb3ZzxdwkqMNJhbX7ksJOHUiFVNtYRjY0zKcsBFiiJdn5N9pg1otSwEb6G8yiuQ7B
8I/NAuzoupZMp8RXZWeXKNp29jUrpXymiNiPgiM0YTOxh8H9OlRBn4BKOJ0wFUG/wFGatrb55Bbn
LOnKB1gGZ+mYpRHOyq1O0TyTLdzkcTEH81aaHuhWOXej3PlVMSl/QaqUw/h/popeT+C4oBloD/hw
Lisw0vna87hQEYcqlEbUHwloHEztgGiB41j4DEEFh8jmV5BD/WtzzvIwaQ27PrVHQyQorEcqEoTs
Qlky0XcKs3q2dlmWLGNkIqo0XZnaaU/IIWFjXQM7em33UAShbqpJVgYM7mT8ue9ZBk1C3eSU882p
IcXaa3Pg7+58bDKDUm4dNg1Nbv9iihWrqh1vhudrb1kR/WHRZrXyrABhpaWgm6X9G07hnEutrVhL
Gjfa+eTAi8saA7FoiFI49EH6H6x/VPjMXjjoBXXM96C2Irhr0MwgbCCqL9nGA+kCaYkTaJws0QaT
ZmVNm7VO2mr5Yn3BnW4h94Sx9czO4u9zGrtozlxxTi5epLEzCzu2trSVpgbPnkxRIE3zjYxxTNXF
0w5O0SSs9zy4/AFHP4QnuD7ygNbQtIamwRPcCUGzZC9yel72kFPgu6UUmGZOaeaYVk5p5ZR2ToHm
LLsyySkdqFT6lgNu2fSPh/ILDejgsguQvKg6t3ObfwAAAP//AwBQSwMECgAAAAAAAAAhACaHaJlH
AQAARwEAABoAAABjbGlwYm9hcmQvbWVkaWEvaW1hZ2UxLnBuZ4lQTkcNChoKAAAADUlIRFIAAAAN
AAAADQgGAAAAcuvkfAAAAARnQU1BAACvyDcFiukAAAAZdEVYdFNvZnR3YXJlAEFkb2JlIEltYWdl
UmVhZHlxyWU8AAAA2UlEQVR42mJ8bWf3n4FEABBATAykg/8AAcT4HwhgvF+nTjH8OniQ4ScQ///8
GSLIwsLA8PcvUClc2R+AAGJ8n5DwmVlRkQeIGbhiY+HGfZ0yhYFZWpqBIzAQwyqAAGJE9hMjDw8D
u4MDA09pKYbCn3v2MPy5cYPh74sX3wACiBFbQIgAnQd2x/XrDN9Xr2b4dfw4w/9v3+DyAAHEgq6B
WVYWzv7c2cnw9/59DFsBAghTE9BvIPDG3h5n8AEEECM58QQQQOTEEwNAAJGlCSCAyNIEEEBkaQII
MADEK0IwObweKwAAAABJRU5ErkJgglBLAQItABQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAAAAA
AAAAAAAAAAAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAi0AFAAGAAgAAAAhAK0wP/HBAAAAMgEA
AAsAAAAAAAAAAAAAAAAARQEAAF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhAFN6GzHrAQAAVwQA
AB8AAAAAAAAAAAAAAAAALwIAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWxQSwECLQAU
AAYACAAAACEAU1KJYdIAAACrAQAAKgAAAAAAAAAAAAAAAABXBAAAY2xpcGJvYXJkL2RyYXdpbmdz
L19yZWxzL2RyYXdpbmcxLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhAItmLWi8BgAA6RsAABoAAAAA
AAAAAAAAAAAAcQUAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1sUEsBAi0ACgAAAAAAAAAhACaH
aJlHAQAARwEAABoAAAAAAAAAAAAAAAAAZQwAAGNsaXBib2FyZC9tZWRpYS9pbWFnZTEucG5nUEsF
BgAAAAAGAAYArwEAAOQNAAAAAA==
" alt="Cardinal Health" type="#_x0000_t75" o:spid="_x0000_s1027"><v:imagedata o:title="" src="file:///C:\DOCUME~1\jschoen\LOCALS~1\Temp\msohtmlclip1\01\clip_image001.png"></v:imagedata><?xml:namespace prefix = x ns = "urn:schemas-microsoft-com:office:excel" /><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Bitmap</x:CF> <x:AutoPict></x:AutoPict></x:ClientData></v:shape>Cardinal</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 135pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=180>1218 Third Avenue South</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 113pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=151>Phone:</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 98pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=130>(205) 324-3673</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 152pt; HEIGHT: 25.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl66 height=34 width=202>(Cardinal Health)</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 135pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=180>Birmingham, AL 35233</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 113pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=151>Fax:</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 98pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=130>(205) 324-3433</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 498pt; HEIGHT: 15.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 height=21 width=663 colSpan=4>Blank row</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 152pt; HEIGHT: 25.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 height=34 width=202><v:shape style="Z-INDEX: 2; POSITION: absolute; MARGIN-TOP: 24.75pt; WIDTH: 10.5pt; HEIGHT: 10.5pt; VISIBILITY: visible; MARGIN-LEFT: 0px" id=Picture_x0020_5 o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW
nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE
APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N
bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9
Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/
8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj
39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB
BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ
TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA
ACEAXZ4wResBAABXBAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWykVMFu2zAM
vQ/YPwi6r449dF2NOsWQrt2Argu27gMYmY6FyZJAKU7696NsJw0CbAPaG0VST4+PpK6ud50RPVLQ
zlYyP5tJgVa5Wtt1JX893r77KEWIYGswzmIlnzDI6/nbN1dQrgl8q5VgBBtKqGQboy+zLKgWOwhn
zqPlWOOog8hHWmc1wZaRO5MVs9mHrANt5fwZ6gYiiA3pF0AZp35jvQDbQ2BIo8pjz8TRqNcjQ2n7
O/I//ZISc/XQL0noupKsnIWOJZLZFJjS+Jid3Fo/A+wa6lK+axqxG1CeKlm8v8gvivMRCXdRKA7l
RX5Z8CuKEyZ7fKn9/te7qv38z9tMbCTAxhEpr1XiZPulVqd15rPicl8qh+OGUJxLUWNQVMkFEM8O
GPEFwcT2oMUBiKHvuVdBWLdowa7xU/CoIpfEoHsXkdu2CHVI7lG/JPRIZhDzgLcy2t9qYxLfZE+t
Zir/H0fWXCu8cWrToY3jTBIaiLwModU+SEEldivk9tLXmhkq3oXIPfakbRyLC6R+cAFDK0IkjKpN
XBrmNPmZ8CHA9jHjwGMkVttvrmZQ2EQ3rMNrZ4If2UN4CvEOXSeSwVUw0+EJ6O9D4syp+5Sh4y5p
OfoTtzEhTUN2slJDZPoC0t4en+d/AAAA//8DAFBLAwQUAAYACAAAACEAU1KJYdIAAACrAQAAKgAA
AGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc6yQwUoEMQyG74LvUHK3
mdmDiGxnLyLsVdYHCG2mU5ympa3ivr3VvTiw4MVLIAn58vHvD59xVR9cakhiYNQDKBabXBBv4PX0
fPcAqjYSR2sSNnDmCofp9mb/wiu1flSXkKvqFKkGltbyI2K1C0eqOmWWvplTidR6Wzxmsm/kGXfD
cI/lNwOmDVMdnYFydDtQp3Pun/9mp3kOlp+SfY8s7coLbN2LO5CK52ZA68vkUkfdXQGva4z/qRFi
j2CjEdkFwp/5qLP4bw3cRDx9AQAA//8DAFBLAwQUAAYACAAAACEAi2YtaLwGAADpGwAAGgAAAGNs
aXBib2FyZC90aGVtZS90aGVtZTEueG1s7FlPbxw1FL8j8R2subfZ/81G3VTZzW4Lbdoo2Rb16J3x
zrjxjEe2N+neUHtEQkIUxAWJGwcEVGolLuXTBIqgSP0KPNszs+PsLElKBAKaQ3bmzc/v+f31s331
2sOYoUMiJOVJz6tfrnmIJD4PaBL2vLvj0aV1D0mFkwAznpCeNyfSu7b57jtX8YbPaDrhWATjiMQE
AaNEbuCeFymVbqytSR/IWF7mKUng25SLGCt4FeFaIPARCIjZWqNW66zFmCbeJnBUmtGQwb9ESU3w
mdjXbAhKcAzS70yn1CcGGxzUNULO5YAJdIhZzwOeAT8ak4fKQwxLBR96Xs38eWubV9fwRjaIqRVj
S+NG5i8blw0IDhpGpggnhdD6qNW9sl3wNwCmlnHD4XAwrBf8DAD7Pmhq51Lm2Rqt1/s5zxLIPi7z
HtTatZaLL/FvLs252+/3291sLpapAdnH1hJ+vdZpbTUcvAFZfHsJ3+pvDQYdB29AFt9Zwo+udDst
F29AEaPJwRJaO3Q0yrgXkClnNyrh6wBfr2XwBQqioYguLWLKE7Uq1mL8gIsRADSQYUUTpOYpmWIf
YnKA44mgWAvAGwSXvliSL5dIWhaSvqCp6nnvpzjxSpDXL759/eIZev3i6fGj58ePfjh+/Pj40feW
lzPwBk7C8sBXX3/y+5cfot+effXqyWfVeFnG//zdRz/9+Gk1EDJooeHLz5/+8vzpyy8+/vWbJxXw
LYEnZfiYxkSi2+QI7fEYdDOGcWdOJuJ8I8YRps4IHAHvCtZDFTnA23PMqnB94hrvnoDiUQW8Pnvg
zHU/EjNFKyTfjGIHuMM563NRaYCbWlbJwuNZElYLF7Mybg/jwyrZA5w4rh3OUqiaeVA6th9ExJnm
LsOJwiFJiEL6Gz8gpEK7+5Q6dt2hvuCSTxW6T1Ef00qTjOnECaTFoBs0Br/Mq3QGVzu22bmH+pxV
ab1NDl0kJARmFZMfE+aY8TqeKRxXsRzjmJUNfgurqGqS+3Phl3FDqcDTIWEcDQMiZdWYOwL0LTn9
JoZ6Ven2HTaPXaRQ9KCK5y3MeRm5zQ8GEY7TKuw+TaIy9j15ACGK0S5XVfAd7maIfgc/4GSlu+9R
4rj79EJwl4bOlBYBor/MhPYlFGqn/sY0+bNizChUYxsDb4txz9uCpakqJW6cKMGrcP/CwruNZ8ku
gVhfXnje1t23ddf7z9fdVbl81mq7KLBQe3XzYPti0yXHK5vkKWVsX80ZuSVNnyxhsQhGQNTjzGaQ
FJumNILHrLg7uFBgMwYJrj6gKtqPcAo9dt3TTEKZsQ4lSrmEvZ0hV/LWeOjTld0ZtvWewdYDidUO
Dyy5qcn51qBgY5ac0Ow/c0FNzeCswppXMqag9psIq+tJnVla3UzNlDpHWqEy+HBZNSAW1oQuBEHv
AlbuwHZci4a9CWYk0Ha3C3DuFuOFi3SRjHBAMh9pvZd9VDdOymPFHAZA7FT4SO/zTrFaSVpXs/0L
0s7ipLK41gpxuff+ipfyCF54SeftiXRkSTk5WYKOel633Wh7yMdpz5vCthYe4xS8LnXjh1kIB0K+
EjbsT01mk+ULb3ZzxdwkqMNJhbX7ksJOHUiFVNtYRjY0zKcsBFiiJdn5N9pg1otSwEb6G8yiuQ7B
8I/NAuzoupZMp8RXZWeXKNp29jUrpXymiNiPgiM0YTOxh8H9OlRBn4BKOJ0wFUG/wFGatrb55Bbn
LOnKB1gGZ+mYpRHOyq1O0TyTLdzkcTEH81aaHuhWOXej3PlVMSl/QaqUw/h/popeT+C4oBloD/hw
Lisw0vna87hQEYcqlEbUHwloHEztgGiB41j4DEEFh8jmV5BD/WtzzvIwaQ27PrVHQyQorEcqEoTs
Qlky0XcKs3q2dlmWLGNkIqo0XZnaaU/IIWFjXQM7em33UAShbqpJVgYM7mT8ue9ZBk1C3eSU882p
IcXaa3Pg7+58bDKDUm4dNg1Nbv9iihWrqh1vhudrb1kR/WHRZrXyrABhpaWgm6X9G07hnEutrVhL
Gjfa+eTAi8saA7FoiFI49EH6H6x/VPjMXjjoBXXM96C2Irhr0MwgbCCqL9nGA+kCaYkTaJws0QaT
ZmVNm7VO2mr5Yn3BnW4h94Sx9czO4u9zGrtozlxxTi5epLEzCzu2trSVpgbPnkxRIE3zjYxxTNXF
0w5O0SSs9zy4/AFHP4QnuD7ygNbQtIamwRPcCUGzZC9yel72kFPgu6UUmGZOaeaYVk5p5ZR2ToHm
LLsyySkdqFT6lgNu2fSPh/ILDejgsguQvKg6t3ObfwAAAP//AwBQSwMECgAAAAAAAAAhACaHaJlH
AQAARwEAABoAAABjbGlwYm9hcmQvbWVkaWEvaW1hZ2UxLnBuZ4lQTkcNChoKAAAADUlIRFIAAAAN
AAAADQgGAAAAcuvkfAAAAARnQU1BAACvyDcFiukAAAAZdEVYdFNvZnR3YXJlAEFkb2JlIEltYWdl
UmVhZHlxyWU8AAAA2UlEQVR42mJ8bWf3n4FEABBATAykg/8AAcT4HwhgvF+nTjH8OniQ4ScQ///8
GSLIwsLA8PcvUClc2R+AAGJ8n5DwmVlRkQeIGbhiY+HGfZ0yhYFZWpqBIzAQwyqAAGJE9hMjDw8D
u4MDA09pKYbCn3v2MPy5cYPh74sX3wACiBFbQIgAnQd2x/XrDN9Xr2b4dfw4w/9v3+DyAAHEgq6B
WVYWzv7c2cnw9/59DFsBAghTE9BvIPDG3h5n8AEEECM58QQQQOTEEwNAAJGlCSCAyNIEEEBkaQII
MADEK0IwObweKwAAAABJRU5ErkJgglBLAQItABQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAAAAA
AAAAAAAAAAAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAi0AFAAGAAgAAAAhAK0wP/HBAAAAMgEA
AAsAAAAAAAAAAAAAAAAARQEAAF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhAF2eMEXrAQAAVwQA
AB8AAAAAAAAAAAAAAAAALwIAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWxQSwECLQAU
AAYACAAAACEAU1KJYdIAAACrAQAAKgAAAAAAAAAAAAAAAABXBAAAY2xpcGJvYXJkL2RyYXdpbmdz
L19yZWxzL2RyYXdpbmcxLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhAItmLWi8BgAA6RsAABoAAAAA
AAAAAAAAAAAAcQUAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1sUEsBAi0ACgAAAAAAAAAhACaH
aJlHAQAARwEAABoAAAAAAAAAAAAAAAAAZQwAAGNsaXBib2FyZC9tZWRpYS9pbWFnZTEucG5nUEsF
BgAAAAAGAAYArwEAAOQNAAAAAA==
" alt="Cardinal Health" type="#_x0000_t75" o:spid="_x0000_s1028"><v:imagedata o:title="" src="file:///C:\DOCUME~1\jschoen\LOCALS~1\Temp\msohtmlclip1\01\clip_image001.png"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Bitmap</x:CF> <x:AutoPict></x:AutoPict></x:ClientData></v:shape>Cardinal</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 135pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=180>105 Thomas Drive</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 113pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=151>Phone:</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 98pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=130>(256) 413-3673</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 152pt; HEIGHT: 25.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl66 height=34 width=202>(Cardinal Health)</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 135pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=180>Gadsden, AL 35904</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 113pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=151>Fax:</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 98pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 width=130>(256) 413-3177</TD></TR></TBODY></TABLE>
I would like to make each record a single row. How do I do that?
Thanks,
Jerry
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Sort by date Sort by votes
Hello and welcome to The Board.
Have a look at my replies to http://www.mrexcel.com/forum/showthread.php?t=569388 which has a link to a Podcast that may help.
The quality is not good - it may be a 'recovered' version as I know that several podcasts got 'lost'. The original was fine and you will see that, in that post, I give the important formula that cannot clearly be seen.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
623
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
921
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C

Forum statistics

Threads
1,224,599
Messages
6,179,828
Members
452,946
Latest member
JoseDavid

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top