Search : in
By :

Take a single cell and divide it into rows

Last answer on Aug 20, 2009 2:13:07 am BST Sarah4, on Aug 19, 2009 7:19:47 pm BST 
 Report this message to moderators

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.

Configuration: Windows XP
Firefox 3.0.13

Best answers for « take a single cell and divide it into rows » in :
Configure Orkut ShowConfigure Orkut The last link of the left side banner, 'settings', provides access to configuration options orkut: The settings are divided into four tabs: • General - here you select the language to be used in the interface of...
Upgrading your laptop ShowUpgradig your laptop Components Internal components External components More informations It's not really easy to upgrade components on a laptop. Upgrading a laptop is divided into 2 categories: Components Internal...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
Download SIW ShowSIW is an advanced System Information for Windows tool that gathers detailed information about your system properties and settings and displays it in an extremely comprehensible manner. The system information is divided into few major...
Download Fomine Net Send GUI ShowThe Fomine Net WSend is very simple to use. It has a user friendly interface that is divided into two where the top one contains the list of LAN contacts and the bottom one is the area where the messages are sent and received. Features: This...
Download PC Health Optimizer ShowPC Health Optimizer Free Edition is a free utility offering a multitude of tools to repair, clean, manage, and optimize Windows disinfects. Advantage All features are accessible from the main window where they are divided into six...
ADSL ShowWhat does xDSL and ADSL mean? The term DSL or xDSL means Digital Subscriber Line and covers all technologies installed for digital transport of information over a single telephone line connection. xDSL technologies are divided into two main...
Formatting - Formatting a hard drive ShowBefore trying to understand formatting, you first need to understand how a hard drive works. Many people do not distinguish low-level formatting (also called physical formatting) from high-level formatting (also called logical formatting). Even...
URL manipulation attacks ShowIntroduction to URLs The URL (Uniform Resource Locator) of a web application is the vector that makes it possible to indicate the requested resource. It is a string of printable ASCII characters that is divided into five parts: The name of the...

1

 venkat1926, on Aug 20, 2009 2:13:07 am BST
  • +1

Post one row of data col A to G

Reply to venkat1926