How to transpose data(rows to column) from different rows of a worksheet?
K kaushik03 Member Sep 15, 2011 #1 How to transpose data(rows to column) from different rows of a worksheet?
Hui Excel Ninja Staff member Sep 16, 2011 #2 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.
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 Member Sep 16, 2011 #3 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...
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...
