Re: Arrange horizontal data to be vertical

Created a helper column H
H2

=COUNTA(B2:D$2)-COUNTA(B2:D2)+1

Try this formula and copy towards down up to H10 then
A15

=INDEX($A$2:$A$10,MATCH(ROWS($A$15:$A15),$H$2:$H$10))

B15

=INDEX($A$2:$D$10,MATCH(ROWS($A$15:$A15),$H$2:$H$10),ROWS($A$15:$A15)-LOOKUP(ROWS($A$15:$A15),$H$2:$H$10)+2)

C15

=INDEX($A$2:$G$10,MATCH(ROWS($A$15:$A15),$H$2:$H$10),ROWS($A$15:$A15)-LOOKUP(ROWS($A$15:$A15),$H$2:$H$10)+5)

Try the above and copy towards down
see the attached file