Transposing Horizontal to Vertical and keep one cell value

Hello,
I have been trying to transpose a bunch of data and cant seem to get it working properly.

this is the raw data sheet 1.
COL A | COL W | COL X | COL Y | COL Z |
Item1 | result1 | result2 | result3 | result4 |
Item2 | result1 | result2 | result3 | result4 |


I need to transpose to this on a different sheet 2:
COL A | COL B
Item1 | result1
Item1 | result2
Item1 | result3
Item1 | result4
Item2 | result1
Item2 | result2
Item2 | result3
Item2 | result4


Transpose will not allow me to repeat the item number the 4x's down.

Assuming you have a header row in row 1 of your raw_data sheet, so that the data starts in row 2. put this formula in A2 of Sheet2:

=INDEX(raw_data!A:A,INT((ROWS($1:1)-1)/4)+2)&""

and this one in B2 of Sheet2:

=INDEX(raw_data!$W:$Z,INT((ROWS($1:1)-1)/4)+2,MOD(ROWS($1:1)-1,4)+1)&""

Copy these formulae down until you start to get blanks returned.

Hope this helps.

Pete