Columns to Lines

Basic Exercise


Create a subroutine that will transfer the contents of a column into a line of another worksheet.

Suggested Concepts:

Remember that in most cases there is more than one way to solve the exercise.

Hint: Create two loops, one within the other, that will invert the cells position from (i, j) to (j, i).

Show Answer

Download exercise Download answer is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2024 SuperExcelVBA | ABOUT

Protected by Copyscape