How to transpose data(rows to column) from different rows of a worksheet?
VBA-Transpose data from different rows(3 posts) (3 voices)
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.
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...
You must log in to post.