How do I create a name/address/phone 3-column list from Excel work

C

casey

Have name,address,phone and date info on Excel 2003 worksheet. Need to put
it in a list much like 3-column labels, but not a label template (without
retyping it).
Any suggestions appreciated.
 
G

Gord Dibben

casey

Show us an example of your existing data and how you want the output to look.


Gord Dibben MS Excel MVP
 
C

casey

In Excel the columns across are: First, Maiden, Last, Street, City, State,
Zip, Phone, Date. I need to make a phone directory out of this information.
If I could change the information to rows, I could cut/paste to make the 3
columns.
Thanks :)
 
G

Gord Dibben

You have 9 columns of data?

Which of these 9 do you want included in the new 3-column format.

I take it you want some of the columns combined.

Which will be combined?


Gord
 
C

casey

You are a quick responder - thanks.
I did a mail merge from Word that worked mostly. I'm cleaning it up now.
If it doesn't end up giving the results I need, I'll let you know.
Thanks again.
:)
 
Top