Excel macro to transpose horizontal data to vertical

How could I take the data in the attached workbook (A1:F6) and transpose it into two columns using a macro?

Hi

here goes

Please Login or Register  to view this content.

rylo

Thank you rylo, this seems to do the trick.

This code is very useful. But when used on huge data range it becomes slow.. Sir can you pls help me in this..