![]() Transposing data in an Excel spreadsheet allows you to copy a series of data that is currently in a row, then paste that same data into a column instead. This can be frustrating, and the prospect of essentially redoing the exact same task again might not be appealing.įortunately, you can convert a row into a column in Excel 2013 by taking advantage of a feature called Transpose. Occasionally you might find that you have laid out data in a spreadsheet in a different manner than you actually need it. Our guide continues below with additional information on how to switch a row to a column in Excel, including pictures of these steps. Click the Paste button, then select the Transpose option.Click the cell where you want to paste the data.Right-click a selected cell and choose Copy.4 Additional Sources How to Convert a Row Into a Column in Excel
0 Comments
Leave a Reply. |