Hi All,
I want to create a code that would automatically
loop to cut and paste data from one row to become
one column.

Lay out before :

Row 1 : Aku Saya Hamba Daku
Row 2 : Kamu Anda Dikau Saudara

Lay out after

Column A Column B
Aku Kamu
Saya Anda
Hamba Dikau
Daku Saudara

Thank's

Rgds,
Shiro