I exported a mailing list file from a database into an excel
spreadsheet.
The problem is the data separated into one line = one cell in the
column, such as

R1C1 John Doe
R2C1 300 Main Street
R3C1 Anytown, USA 66666

I need to get all three rows into one row.
There is a blank row between each record.

I expect I need to grab rows 2 and 3 and add them to row 1, but
keeping the data in 3 lines, not in one long line in the cell.

I guess that the blank row can stay as is - I'll know more about this
when I start to use the data.

I tried to do this with a macro but it only wants to deal with one
cell at a time. I tried typing the second line in at the data input
box but I don't know how to get it to take the data and split it into
3 lines of data in one cell.

Could someone please help me with this. I am familiar with VBA in
MSWord and MSAccess and a bit in Outlook, but this is my first stab at
it in Excel.

My appreciation for your time and expertise
Joanne