I need Help! Badly! How to split a single cell into multiple rows!

[SariJo10]

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CSarahJo%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><link rel="Edit-Time-Data" href="file:///C:%5CDOCUME%7E1%5CSarahJo%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_editdata.mso"><!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><o:smarttagtype namespaceuri="urn:schemas-microsoft-comffice:smarttags" name="City"></o:smarttagtype><o:smarttagtype namespaceuri="urn:schemas-microsoft-comffice:smarttags" name="place"></o:smarttagtype><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if !mso]>******** classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {colorurple; text-decoration:underline; text-underline:single;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} table.MsoTableGrid {mso-style-name:"Table Grid"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-border-insideh:.5pt solid windowtext; mso-border-insidev:.5pt solid windowtext; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Hi Everyone!

I am new here and need some help. I have Microsoft Excel 2003, not all that experience and have never used Macros. I am designing a database for my uncle and have reached a problem. Currently my data looks like this:

Column A1 is business name and is fine
Column B1, C1 is city and address which are also fine
Columns D1, E1, F1, and G1 is where my problem arises. Each of these columns will need multiple lines of data in them. D1 is contacts (and for some companies I have 10+ contacts) E1 is contact title (need this to line up with D1), F1 is contact email and G1 is contact phone number. I need all of these to line up. Currently I just have them on separate lines, but some do not line up. How can I divide these cells into separate rows (not columns) so they have lines and are easy to read and follow? Any help would be much appreciated!! <o></o>

Here is an example of what I need. I did this in word; however, I want to do it in excel (that is what my Uncle would like). I already have the company name, city, and state done. I am doing the contacts and rest of the information now. If you think there is a better way to organize this let me know. But here is what I would like to do:

<u1:smarttagtype namespaceuri="urn:schemas-microsoft-comffice:smarttags" name="City"></u1:smarttagtype><u1:smarttagtype namespaceuri="urn:schemas-microsoft-comffice:smarttags" name="place"></u1:smarttagtype><!--[if gte mso 9]><xml> <u2:WordDocument> <u2:View>Normal</u2:View> <u2:Zoom>0</u2:Zoom> <u2:PunctuationKerning/> <u2:ValidateAgainstSchemas/> <u2:SaveIfXMLInvalid>false</u2:SaveIfXMLInvalid> <u2:IgnoreMixedContent>false</u2:IgnoreMixedContent> <u2:AlwaysShowPlaceholderText>false</u2:AlwaysShowPlaceholderText> <u2:Compatibility> <u2:BreakWrappedTables/> <u2:SnapToGridInCell/> <u2:WrapTextWithPunct/> <u2:UseAsianBreakRules/> <u2:DontGrowAutofit/> </u2:Compatibility> <u2:BrowserLevel>MicrosoftInternetExplorer4</u2:BrowserLevel> </u2:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <u3:LatentStyles DefLockedState="false" LatentStyleCount="156"> </u3:LatentStyles> </xml><![endif]--> <o></o>
<table class="MsoTableGrid" style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style=""> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 69.35pt;" valign="top" width="92"> Name<o></o>
</td> <td style="border-style: solid solid solid none; border-color: -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 87.6pt;" valign="top" width="117"> City<o></o>
</td> <td style="border-style: solid solid solid none; border-color: -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 34.8pt;" valign="top" width="46"> State<o></o>
</td> <td style="border-style: solid solid solid none; border-color: -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt;" valign="top" width="98"> Contact<o></o>
</td> <td style="border-style: solid solid solid none; border-color: -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt;" valign="top" width="156"> Email<o></o>
</td> <td style="border-style: solid solid solid none; border-color: -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt;" valign="top" width="81"> Phone<o></o>
</td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 69.35pt;" valign="top" width="92"> Nike<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 87.6pt;" valign="top" width="117"><st1:city u4:st="on"><st1lace u4:st="on"> <st1:city w:st="on"><st1lace w:st="on">Los Angeles</st1lace></st1:city><o></o>
</st1lace></st1:city></td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 34.8pt;" valign="top" width="46"> CA<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt;" valign="top" width="98"> Sarah Down<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt;" valign="top" width="156"> Sdown@yahoo.com<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt;" valign="top" width="81"> 555-1234<o></o>
</td> </tr> <tr style="height: 13.8pt;"> <td rowspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 69.35pt; height: 13.8pt;" valign="top" width="92"> Footlocker<o></o>
</td> <td rowspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 87.6pt; height: 13.8pt;" valign="top" width="117"><st1:city u4:st="on"><st1lace u4:st="on"> <st1:city w:st="on"><st1lace w:st="on">Los Angeles</st1lace></st1:city><o></o>
</st1lace></st1:city></td> <td rowspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 34.8pt; height: 13.8pt;" valign="top" width="46"> CA<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 13.8pt;" valign="top" width="98"> Billy Bob<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 13.8pt;" valign="top" width="156"> Bb1@aol.com<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 13.8pt;" valign="top" width="81"> 444-1234<o></o>
</td> </tr> <tr style="height: 13.75pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 13.75pt;" valign="top" width="98"> Katie Smith<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 13.75pt;" valign="top" width="156"> ks@aol.com<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 13.75pt;" valign="top" width="81"> 454-6171<o></o>
</td> </tr> <tr style="height: 4.8pt;"> <td rowspan="6" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 69.35pt; height: 4.8pt;" valign="top" width="92"> Hilton Hotels<o></o>
</td> <td rowspan="6" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 87.6pt; height: 4.8pt;" valign="top" width="117"><st1:city u4:st="on"><st1lace u4:st="on"> <st1:city w:st="on"><st1lace w:st="on">Los Angeles</st1lace></st1:city><o></o>
</st1lace></st1:city></td> <td rowspan="6" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 34.8pt; height: 4.8pt;" valign="top" width="46"> CA<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.8pt;" valign="top" width="98"> Joe Smith<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.8pt;" valign="top" width="156"> jsmith@aol.com<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.8pt;" valign="top" width="81"> 555-1234<o></o>
</td> </tr> <tr style="height: 4.55pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.55pt;" valign="top" width="98"> Mary Jones<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.55pt;" valign="top" width="156"> jones@aol.com<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.55pt;" valign="top" width="81"> 600-1455<o></o>
</td> </tr> <tr style="height: 4.55pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.55pt;" valign="top" width="98"> Sarah Murphy<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.55pt;" valign="top" width="156"> smurphy@yahoo.com<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.55pt;" valign="top" width="81"> 800-1234<o></o>
</td> </tr> <tr style="height: 4.55pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.55pt;" valign="top" width="98"> John Doe<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.55pt;" valign="top" width="156"> jdoe@gmail.com<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.55pt;" valign="top" width="81"> 234-4253<o></o>
</td> </tr> <tr style="height: 4.55pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.55pt;" valign="top" width="98"> Jane Doe<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.55pt;" valign="top" width="156"> jadoe@gmail.com<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.55pt;" valign="top" width="81"> 235-6898<o></o>
</td> </tr> <tr style="height: 4.55pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.55pt;" valign="top" width="98"> Bob Hope<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.55pt;" valign="top" width="156"> bhope@yahoo.com<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.55pt;" valign="top" width="81"> 234-5690<o></o>
</td> </tr> </tbody></table>

 

[jbeaucaire]

Can you post an example of what the data looks like initially?

 

[hiker95]

SariJo10,

If your data in Excel looks like this:

Excel Workbook
	A	B	C	D	E	F
1	Name	City	State	Contact	Email	Phone
2	Nike	Los Angeles	CA	Sarah Down	Sdown@yahoo.com	555-1234
3	Footlocker	Los Angeles	CA	Billy Bob	Bb1@aol.com	444-1234
4				Katie Smith	ks@aol.com	454-6171
5	Hilton Hotels	Los Angeles	CA	Joe Smith	jsmith@aol.com	555-1234
6				Mary Jones	jones@aol.com	600-1455
7				Sarah Murphy	smurphy@yahoo.com	800-1234
8				John Doe	jdoe@gmail.com	234-4253
9				Jane Doe	jadoe@gmail.com	235-6898
10				Bob Hope	bhope@yahoo.com	234-5690
Sheet1

And you want it to look like this:

Excel Workbook
	A	B	C	D	E	F
1	Name	City	State	Contact	Email	Phone
2	Nike	Los Angeles	CA	Sarah Down	Sdown@yahoo.com	555-1234
3	Footlocker	Los Angeles	CA	Billy Bob	Bb1@aol.com	444-1234
4	Footlocker	Los Angeles	CA	Katie Smith	ks@aol.com	454-6171
5	Hilton Hotels	Los Angeles	CA	Joe Smith	jsmith@aol.com	555-1234
6	Hilton Hotels	Los Angeles	CA	Mary Jones	jones@aol.com	600-1455
7	Hilton Hotels	Los Angeles	CA	Sarah Murphy	smurphy@yahoo.com	800-1234
8	Hilton Hotels	Los Angeles	CA	John Doe	jdoe@gmail.com	234-4253
9	Hilton Hotels	Los Angeles	CA	Jane Doe	jadoe@gmail.com	235-6898
10	Hilton Hotels	Los Angeles	CA	Bob Hope	bhope@yahoo.com	234-5690
Sheet1

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code/or instructions, you never know what you might lose).

Then select columns A, B, and C, and:
Press F5, click Special, tick Blanks, click OK.
Press =
Press Up arrow
Press CTRL + Enter
Select the columns, Edit > Copy, Edit > Paste Special, tick Values, click OK.

 

[SariJo10]

Thanks for your help. I never thought about doing it the way you have it. Currently, here is an example (I still have lots of data to enter):

I am trying to paste my data but it loses the formatting every time. How can I paste it so you can see it as it looks right now??

<table x:str="" style="border-collapse: collapse; width: 961pt;" width="1280" border="0" cellpadding="0" cellspacing="0"><col style="width: 237pt;" width="316"> <col style="width: 133pt;" width="177"> <col style="width: 48pt;" width="64"> <col style="width: 108pt;" width="144"> <col style="width: 209pt;" width="278"> <col style="width: 127pt;" width="169"> <col style="width: 99pt;" width="132"> <tbody><tr style="height: 25.5pt;" height="34"> <td class="xl26" style="height: 25.5pt; width: 237pt;" x:str="Hilton Hotels Corporation " width="316" height="34">
</td> <td class="xl27" style="width: 133pt;" width="177">
</td> <td class="xl26" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 108pt;" width="144">Ram Avvari
Tim Harvey</td> <td class="xl24" style="width: 209pt;" width="278">PM
CIO</td> <td class="xl25" style="width: 127pt;" width="169">rpavvari@yahoo.com
</td> <td class="xl24" style="width: 99pt;" width="132">(613) 946-1964
(310) 278-4321</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt;" height="17">
</td> <td class="xl27">
</td> <td class="xl26">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 51pt;" height="68"> <td class="xl26" style="height: 51pt;" height="68">
</td> <td class="xl27">
</td> <td class="xl26">
</td> <td class="xl28" style="width: 108pt;" width="144">Anne Kuhns
Dennis Whitlow</td> <td class="xl28" style="width: 209pt;" width="278">Manager, Information Technology Security
Director, Global Data Center Consolidation</td> <td class="xl29">dennis.whitlow@disney.com</td> <td class="xl26">(407) 824-2222</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt;" x:str="The Ryland Group, Inc. " height="17">
</td> <td class="xl27">
</td> <td class="xl26">
</td> <td class="xl26">Jon Bartlett</td> <td class="xl26">Senior Network Security Engineer</td> <td>
</td> <td class="xl26">(818) 223-7500</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt;" x:str="CKE Restaurants, Inc. " height="17">
</td> <td class="xl27">
</td> <td class="xl26">
</td> <td class="xl26">Daniel Baker</td> <td class="xl26">Director of IT Security</td> <td>
</td> <td class="xl26">(714) 778-7198</td> </tr> </tbody></table>

 

[hiker95]

SariJo10,

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[SariJo10]

West Region

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Arial,Arial; font-size: 10pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 316px;"> <col style="width: 177px;"> <col style="width: 64px;"> <col style="width: 144px;"> <col style="width: 278px;"> <col style="width: 169px;"> <col style="width: 132px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td> <td>G</td></tr> <tr style="height: 34px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">2</td> <td>Hilton Hotels Corporation </td> <td>Beverly Hills</td> <td>CA</td> <td>Ram Avvari
Tim Harvey</td> <td>PM
CIO</td> <td style="color: rgb(0, 0, 255); text-decoration: underline;">rpavvari@yahoo.com
</td> <td>(613) 946-1964
(310) 278-4321</td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td>Live Nation, Inc.</td> <td>Beverly Hills</td> <td>CA</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td></tr> <tr style="height: 34px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td>The Walt Disney Company</td> <td>Burbank</td> <td>CA</td> <td>Anne Kuhns
Dennis Whitlow</td> <td>Manager, Information Technology Security
Director, Global Data Center Consolidation</td> <td style="color: rgb(0, 0, 255); text-decoration: underline;">dennis.whitlow@disney.com</td> <td>(407) 824-2222
(818) 560-6668</td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td>The Ryland Group, Inc. </td> <td>Calabasas</td> <td>CA</td> <td>Jon Bartlett</td> <td>Senior Network Security Engineer</td> <td>
</td> <td>(818) 223-7500</td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td> <td>CKE Restaurants, Inc. </td> <td>Carpinteria</td> <td>CA</td> <td>Daniel Baker</td> <td>Director of IT Security</td> <td>
</td> <td>(714) 778-7198</td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">7</td> <td>Jacuzzi Brands Corporation</td> <td>Chino Hills</td> <td>CA</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td></tr></tbody></table>

Excel tables to the web >> Excel Jeanie HTML 4

 

[SariJo10]

Thank you Hiker so much for your help! That is what it currently looks like. I have about 15 contacts for Walt Disney alone, and I have just been using Alt+ Enter to put them on separate lines. The problem is, when I am done they don't line up. What do you suggest?

 

[SariJo10]

Also, I should've probably said that what I wanted to do was keep it all in one cell, and just create rows within the cell. If I have to, I can do it the way you showed me, it will just end up being longer in length.

 

[hiker95]

SariJo10,

I just pasted your posted data, and ran a macro that I have, and here is what I got:

Excel Workbook
	A	B	C	D	E	F	G
2	Hilton Hotels Corporation	Beverly Hills	CA	Ram Avvari	PM	rpavvari@yahoo.com	(613) 946-1964
3				Tim Harvey	CIO		(310) 278-4321
4	Live Nation, Inc.	Beverly Hills	CA
5	The Walt Disney Company	Burbank	CA	Anne Kuhns	Manager, Information Technology Security	dennis.whitlow@disney.com	(407) 824-2222
6				Dennis Whitlow	Director, Global Data Center Consolidation		(818) 560-6668
7	The Ryland Group, Inc.	Calabasas	CA	Jon Bartlett	Senior Network Security Engineer		(818) 223-7500
8	CKE Restaurants, Inc.	Carpinteria	CA	Daniel Baker	Director of IT Security		(714) 778-7198
9	Jacuzzi Brands Corporation	Chino Hills	CA
West Region

I have been involed with database management for a long time, and your screenshot does not make sense to me, especially if you were searching for one person's name.


This makes more sense to me (my personal preference):

Excel Workbook
	A	B	C	D	E	F	G
2	Hilton Hotels Corporation	Beverly Hills	CA	Ram Avvari	PM	rpavvari@yahoo.com	(613) 946-1964
3	Hilton Hotels Corporation	Beverly Hills	CA	Tim Harvey	CIO		(310) 278-4321
4	Live Nation, Inc.	Beverly Hills	CA
5	The Walt Disney Company	Burbank	CA	Anne Kuhns	Manager, Information Technology Security	dennis.whitlow@disney.com	(407) 824-2222
6	The Walt Disney Company	Burbank	CA	Dennis Whitlow	Director, Global Data Center Consolidation		(818) 560-6668
7	The Ryland Group, Inc.	Calabasas	CA	Jon Bartlett	Senior Network Security Engineer		(818) 223-7500
8	CKE Restaurants, Inc.	Carpinteria	CA	Daniel Baker	Director of IT Security		(714) 778-7198
9	Jacuzzi Brands Corporation	Chino Hills	CA
West Region

 

[SariJo10]

Thank you so much for all of your help. I never thought of just inserting them in a separate row. This has been bothering me all day. You have no idea how much I appreciate it. If there is anything I can ever help you with (hahaha I doubt it) let me know.

Have a great night!

Sarah
SariJo10@aol.com