Sometime you need to convert rows to column in excel. You can easily copy, or transpose, a row into a column and vice versa by using the transpose feature. To ensure you have room for new worksheet data, you can place the transposed columns or rows on a different worksheet or in a new workbook.
Note: Make sure a series of blank cells is available to accommodate the copied data.
Note: Excel removes existing data by copying over it.
View Comments (1)
Nice poste