(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!