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.
:)

"Gord Dibben" wrote:

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

On Sun, 30 Jul 2006 08:04:01 -0700, casey
wrote:

In Excel the columns across a 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 :)

"Gord Dibben" wrote:

casey

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


Gord Dibben MS Excel MVP

On Fri, 28 Jul 2006 20:46:02 -0700, casey
wrote:

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.