VBA-Transpose data from different rows

[kaushik03]

How to transpose data(rows to column) from different rows of a worksheet?

 

[Hui]

Kaushik03


Firstly, Welcome to the Chandoo.org Forums.


Select the Rows or Data

Copy (Ctrl C)

Select the upper left corner where you want the data copied

Paste Special, Transpose (Ctrl Alt V, e)


Note: You can't Cut and Transpose.

 

[vasim]

Or you can use the array =TRANSPOSE function......Select all the count of rows/columns you want to copy type =transpose and give the array of referenced rows/columns...