|OK, I lied...it took three formulae.|
Here's what I did:
I copied your data into Column A, starting in A1.
In B1 I put:
I then dragged this formula down along side the data to get this in Column B:
123 Apple Creek
Sat Nov 15 18:50:30 CST 2008
In A1 of Sheet2 I put:
In A2 I put =A1+9 and dragged this down, so that Column A showed the row number from Sheet1 that contained the first piece of each data set (Name:)
In Sheet2!B2 I put:
=INDIRECT("Sheet1!B" & COLUMN()+$A1-2)
Drag this across to Column J to bring in the first set of data.
Drag the formulae from B1:J1 down to bring in each subsequent data set.
Once it's all in Sheet2, do a Copy...Paste Special...Values to eliminate the formulae and leave the text.
That was kind of fun..