Convert Multiple Rows to Columns

i don't know if you are allowed to use Macros.

If not then

1. First Select the formulas tab an then Name Manager.

Declare a new Name List using this formula in the refers to box =OFFSET(Sheet1!$A$4,0,0,MATCH("zzzzzzz",Sheet1!$A:$A)-3,1)

2. Enter this formula in I4 using Ctrl Shift Enter and fill down until you see empty cells

=IF(ROW()>SUM(1/COUNTIF(List,List))+3,"",INDEX(List,MATCH(0,COUNTIF($I$3:I3,List),0)))

3. Enter this formula in Cell J4 and fill down until you see empty cells

=IF(OR(I4="",COLUMN()>COUNTIF($A:$A,$I4)*3+9),"",INDEX($B$4:$D$9999,MATCH($I4,$A:$A,0)+INT((COLUMN()-10)/3)-3,MOD(COLUMN()-1,3)+1))

Now fill to the right until you see empty cells.

That should get you started. If this works for you and you are allowed macros and haven't found a solution then let me know.