Transposing Repetitive Serial Fields Into Table Structure

Dear All,

I'm attempting to create a query that will transpose repeated fields
into a single table structure. Can anyone think of how this can be done
as I'm stumped at the minute? I'd like to do this without having to
create a cursor due to the overheads and performance issues associated
with cursors. The table may also include additional fields which I'm
not interested in.

Serial Data is like this.............

IkeyIval
-----------------------------------------------
RAF_EMAILJoin Bytes!
RAF_FIRSTNAMEtestFirstName1
RAF_LASTNAMEtestLastname1
RAF_EMAILJoin Bytes!
RAF_FIRSTNAMEtestFirstName2
RAF_LASTNAMEtestLastname2
....

Transposed into table like this ..............

EmailFirstnameLastname
--------------------------------------------------------------------------
Join Bytes!testFirstName1testLastname1
Join Bytes!testFirstName2testLastname2
....

Any help, much appreciated ...

Kind Regards,

Tim

-------------------------------------------------------------------------------------

NOTE: these create temporary tables ....

DECLARE @XML TABLE
(
ikey VARCHAR(200),
ival VARCHAR(1000)
)

INSERT INTO @XML
SELECT 'RAF_EMAIL', 'testemail1@hotmail.com'
UNION ALL SELECT 'RAF_FIRSTNAME', 'testFirstName1'
UNION ALLSELECT 'RAF_LASTNAME', 'testLastname1'
UNION ALLSELECT 'RAF_EMAIL', 'testemail2@hotmail.com'
UNION ALL SELECT 'RAF_FIRSTNAME', 'testFirstName2'
UNION ALLSELECT 'RAF_LASTNAME', 'testLastname2'
UNION ALLSELECT 'FORM_CATEGORY', 'nothing'
UNION ALLSELECT 'NO_DOGS', '1'


DECLARE @RESULTS
(
EMAIL,
FIRSTNAME,
LASTNAME
)