If this presents a problem, then you can always use the first cell under your target destination row, then delete the original row. Note that the new location of the data cannot overlap the original location of the data. In the tutorial below we will be converting data from a row to a column. Transposing a Row to a Column in Excel 2013 (Guide with Pictures)

This can be immensely helpful when a spreadsheet has been laid out incorrectly, and it can help to minimize potential mistakes that can occur when you need to re-enter large sequences of information. 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

Change from column to row in excel