Help with converting data in Excel

Hello all,

I have been working with a client of mine for the last few weeks to
get a simple data conversion taken care of. However it has turned out
to be more difficult than I expected. I was provided a *.txt file
that had tons of columns and extra data that wasn't needed. The
client just wanted the names & addresses from the files so they could
use those for mailing labels.

I was able to use Excel 2003 to convert the data into a spread sheet
where the names and addresses shows up. Currently the data looks like
this in Excel:

John Doe
123 Fake Street
New York, NY 12345

Jane Doe
456 Fake Street
New York, NY 12345

Thus each field is in a seperate row making it nice and readable.
However I spoke with the print shop and they said that this is NOT a
compatible format for their software. They want it in excel, but to
have each name & address appear on one field, seperated by a row, then
the next row with another name & address seperated by another row,
etc. They want it to look like the following:

John Doe 123 Fake Street New York, NY 12345

Jane Doe 456 Fake Street New York, NY 12345


However when I used a feature that I can't remember the name of now,
it puts ALL records in to one long row and looks like the following:

John Doe 123 Fake Street New York, NY 12345 Jane Doe 456 Fake
Street New York, NY 12345


After checking with the print shop, this too is incompatible with
their format. Does anyone know or can advise to get this data in the
format that the print shop is seeking???

Brad

I started a new sheet and put in a Edit->Fill->Series, Column, Linear,
Step value=4 and got this in column A:

1
5
9
13
17
21
25
29
33
37
.... (and so on ...)

Then in B1:D1, I put in these formulas:

=INDEX([Book1]Sheet1!$A$1:$A$31,$A1,1) <-belongs in B1
=INDEX([Book1]Sheet1!$A$1:$A$31,$A1+1,1) <-belongs in C1
=INDEX([Book1]Sheet1!$A$1:$A$31,$A1+2,1) <-belongs in D1

Where [Book1]Sheet1 is your name and address data. Then I did a Edit-
Fill->Down.

Assuming your names and addresses are three lines each, this should
work for you. Maybe not elegant, but it will work.