Take a single cell and divide it into rows
Closed
Sarah4
-
Aug 19, 2009 at 02:19 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 19, 2009 at 09:13 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 19, 2009 at 09:13 PM
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, and 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!! Thanks in advance.
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, and 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!! Thanks in advance.
Related:
- Take a single cell and divide it into rows
- How to delete a row in a table in word - Guide
- Single sim samsung keypad mobile - Phones, PDA & GPS Forum
- E1200Y sim lock password ✓ - Phones, PDA & GPS Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- Samsung gt-e1200 Password unlock ✓ - Phones, PDA & GPS Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 19, 2009 at 09:13 PM
Aug 19, 2009 at 09:13 PM
post one row of data col A to G