I've got a situation with an old contact list of 2250 personal & business
contacts that open in excel like this:

Name
Street
City, State, Zip
Telephone
Email

Name
Street
City, State, Zip
Telephone
Email

I need some way to take this unmanageable format and make it into an
easy-to-reference table like:

Name - street - city,state,zip - telephone - email
Name - street - city,state,zip - telephone - email

Any suggestions for making this an easy formula so i don't have to spend the
next week organizing them one-at-a-time?

Thanks,
Steve

Source data assumed representative as posted, running in A1 down
In B1: =OFFSET($A$1,ROWS($1:1)*6-6+COLUMNS($A:A)-1,)
Copy B1 across to F1, fill down as far as required to exhaust source data
High-five?, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"The new guy" wrote:
I've got a situation with an old contact list of 2250 personal & business
contacts that open in excel like this:

Name
Street
City, State, Zip
Telephone
Email

Name
Street
City, State, Zip
Telephone
Email

I need some way to take this unmanageable format and make it into an
easy-to-reference table like:

Name - street - city,state,zip - telephone - email
Name - street - city,state,zip - telephone - email

Any suggestions for making this an easy formula so i don't have to spend the
next week organizing them one-at-a-time?

Thanks,
Steve