Horizontal to vertical ( 1 row to 1 column )

[shiro]

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

 

[Mike H]

Hi,

You don't need a macro.
Select your data and then Copy it

Select a cell for the top left column of data then
Edit|Paste Special
Select 'Transpose'
Click OK

Mike