How to Turn repeated uneven blocks of rows into columns array

Hi,
recently I've tried to backup my cellular phone book via the website of the cell phone company, and got an UNSORTED excel in this structure:


XXX
Phone 0546430653
FirstName XXX
LastName
YYY
Phone 0545841753
Phone 035370898
FirstName YYY
LastName
ZZZ QQQ
Phone 0535318890
FirstName ZZZ
LastName QQQ
VVV
FirstName
LastName VVV
Phone 0546366127

Every block represent one memory in my phone book. The first cell of each block is always merged (A+B columns), and the blocks, as seen in the example, are uneven in their size. I found it very hard to move from this structure to basic columns structure (firstnamelastname/phone). if anyone have an advice how you do it, or another way to sort this data I will really appreciate it.

Thanks,
Kim

Please post a small Sample file so we may see what you are talking about.

Thanks

Attached small sample file. Thanks

Hi Melvinrobb,
Yes, it is correct. the structure of each block is not consistent. attached in the reply below is the workbook.

Thanks.

Yes, I'm using excel 2003.

Thanks - it solved the issue!