See your other post.

Changing to a new thread does very little to get you more answers.

Your needs were spelled quite well in your first post.

See my response there.


Gord Dibben MS Excel MVP

On Thu, 15 Feb 2007 09:56:17 -0800, zooeyhallne
wrote:

(I am reposting this message to clarify some things in the original post).

Hi everyone! I am hoping someone can give me answer on formatting data on an
Excel spreadsheet. I am generally knowledgable in Excel, but this one has
got me stumped.
I have been given an Excel spreadsheet with a list of our company's
customers. The data is currently in the following format on the sheet
(numbers in parenthesis are cell reference numbers):

(A1) <customer name #1
(A2) <business name
(A3) <street address
(A4) <city, state, zipcode
(A5) <blank line
(A6) <customer name #2
(A7) <business name
(A8) <street address
(A9) <city, state, zipcode
(A10) <blank line

etc.....

I need to change the sheet so that information for each customer is all in a
row, for example:

(A1) <customer name#1 (B1) <business name (C1) <address (D1) <city,
state, zip
(A2) <customer name #2 (B2) <business name (C2) <address (D2) <city,
state, zipcode

etc.....

There are about 1000 names on this sheet. Is there an easy way I can do
this? Thank you in advance! I truly appreciate any help on this!