Merging columns?

[Carolina78703]

::As it now stands, the spreadsheet is a very wide one-- because of al
the contact fields in the columns across.
I want to be able to consolidate the data so it reads like a grou
contact/phone directory.

So ultimately then-- instead of running way across a loooong row--
person's data would look more compressed---
Like this:

John Doe
111 Park Ave.
NY, NY 12345
phone 212-555-5555
email (e-mail address removed)
birthdate 2-2-1962

I hope this helps-- thank you for your generous time.
Carol:

 

[Debra Dalgleish]

If there are 32 fields or fewer, you can use the built-in data form to
view all the data for one contact --

Select a cell in the table
Choose Data>Form
Use the buttons on the right to find records, or scroll through the
contact list

 

[Jay]

::As it now stands, the spreadsheet is a very wide one-- because of all

the contact fields in the columns across.
I want to be able to consolidate the data so it reads like a group
contact/phone directory.

So ultimately then-- instead of running way across a loooong row-- a
person's data would look more compressed---
Like this:

John Doe
111 Park Ave.
NY, NY 12345
phone 212-555-5555
email (e-mail address removed)
birthdate 2-2-1962

My suggestion is to use Word's Mail Merge feature when you want to present
the phone directory in compressed form.

If it were me, I'd continue to keep the real data in the "loooong row"
format because it's so handy for sorting, filtering, etc.

Using Mail Merge for the viewer-friendly presentation gives the best of
both worlds.

But that's just me.