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>

 

[hiker95]

Sarah,

You are very welcome.

Glad I could help.