Formular to copy data vertically

[issa.o]

Hi
friends i have a data from column AP12 to AX12,
i want to have a table vertically in cell BY16 which contains data from AP12 to AX 12.

[Philb1]

Hi
Select BY16:BY24 and in the formula bar enter

Please Login or Register  to view this content.

the press Ctrl/Shift & Enter simultaneously. It's an array formula

[issa.o]

Hi phib1 it works well but it is difficult to me somehow is there another method?

[Philb1]

How is that difficult? Is it not what you asked for?

[FDibbins]

Try this, copied down and across...
=INDEX($AP$12:$AX$15,COLUMNS($A$1:A1),ROWS($A$1:A1))