How can I display column values pulling from row values?

[stuckagain22]

On A5, I want to pull in A1's value
On B5, I want to pull in A2's value
On C5, I want to pull in A3's value

I would like a formula to do the above that I can copy and paste to put in each cell.

Please help.

Thanks.

 

[northwolves]

A5=INDEX($A$1:$A$3,COLUMN()) ,Drag it right to C5.

Best Regards.