Posted to microsoft.public.excel.misc

external usenet poster

Posts: 186

Converting multiple rows into columns

I am working on a list of contacts that is listed by rows and columns in the
following manner:

Column A Coilumn B

ABC Inc
Address: Primary Contact:
1 Main Street John Doe
Mainvile CT 06405 Business Type:
Contractor/SubContractor
Phone: 203-555-0000
Fax: 203-555-0001
Email:

I need to convert the data into columns to import into my ACT database. CAn
anyone help??? Thanks in advance...

Jack

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting from rows to columns	Tripp K	Excel Discussion (Misc queries)	3	May 9th 07 12:00 PM
Converting columns into rows	Manni	Excel Discussion (Misc queries)	2	March 29th 07 03:12 PM
Converting columns to rows	[email protected]	Excel Worksheet Functions	4	February 15th 07 11:13 PM
(Again) Converting rows to columns	nickr1954	Excel Discussion (Misc queries)	4	January 28th 06 01:22 PM
Converting Columns to Rows	Chris D'Onofrio	Excel Worksheet Functions	1	March 30th 05 08:08 PM

All times are GMT +1. The time now is 01:12 AM.

About Us

"It's about Microsoft Excel"