Transform row to a column

Hello all,

Can i make values that listed in a a row, to shown in a column automatically?

for a example cells A1:1 B1:2 C1:3 D1:4 to become cells A1: 1 A2: 2 A3: 3 A4: 4.

Thank you in advance!