ModernRugs.com interview question

Write a small VBA application to automate transposing a column in Excel.