Formular to copy data

[issa.o]

Hi friends
is there any simple formular to copy data from horizontal to vertically apart from transpose?
I have data in cell A1 to D1
i want to copy in cell E2 to E6
i hope i will get assistance from any experts

[FDibbins]

Something like this?

	A	B	C	D	E
1	aa	bb	cc	dd
2					aa
3					bb
4					cc
5					dd
6

E2=IFERROR(INDEX($A$1:$D$1,,ROWS($A$1:A1)),"")
copied down

[FDibbins]

Happy to help, thanks for the feedback