Try this (credit to Biff for his method of condensing):

Import the data to column A.

In B1 type: =INDEX($A:$A,(ROWS($1:1)-1)*6+COLUMNS($A:B)-1)
This formula effectively looks up each cell in column A in turn and
places them from left to right and down the rows.
Copy this to columns C:G, and hide cols E-F (will be zero) (don't
delete the cols)

In H1 type: =MID(G1,1,FIND("email:",G1)-1)
in I1 type: =MID(G1,FIND("email:",G1)+7,99)

This will separate the last cell into 2 values using the key phrase
"email:"

Copy the formula in cols B:I as far down as need be.

Et voila! (I hope)...

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=568466