Moving data from columns into rows

Hello,

I have data that is in two rows in excel such as this:

3/1/09 Joe Sick John Black hotdog 47 y/o
ID # 123-09-6383 bun
All this data refers to one record. I want this one record to be moved to one row

3/1/09 Joe Sick John Black hot dog 47y/o ID# 123-09-6383 bun

After moving, I want the macro to delete the rows in between, advance to the next record, and move the data. Can this be done. I am very new to macros, just learned about them in an Access class. The final record should look like:

3/1/09 Joe Sick John Black hot dog 47y/o ID# 123-09-6383 bun
3/1/09 Gwen Hi Joe better stew 85y/o ID# 937-84-8353 soda