If the data repeat every four rows, you could use a formula like:
=OFFSET($B$1,(ROW()-2)*4+COLUMN()-3,0)
where:
• 'Name' & 'Result' are in cells A1 & B1, respectively; and
• the formula is input into D2, then copied across to G2 and down as far as needed.
Naturally, you'd also type the a-d column headers in D1-G1.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]