Saturday, May 18, 2024
HomeMicrosoft OfficeMicrosoft ExcelExcel 2013: Convert Columns to Rows

Excel 2013: Convert Columns to Rows

Did you create a spreadsheet and realize that you got the layout mixed up? Did you receive a table or a chart through your email, but you need to reformat it? Excel’s Transpose option will allow you to fix your charts easily.

When to put data into rows or columns is debatable. When receiving a spreadsheet with data entered incorrectly, many users will delete the columns and manually re-enter them in rows. Obviously, this method is slow and painful. The faster way to fix your tables is by using the Transpose feature. By using this feature you can convert your column-based chart to simple table rows.

1.Below is a column-formatted data. Select the whole table. 

2.With the data highlighted, right-click on it, and click Copy

3.Right-click on an empty cell, and select Paste Special and then Paste Special… again. 

4.Under Paste Special, select the check box next to Transpose , and click OK

Through these steps you will be left with your reformatted table.

Alex Bahdanovich
Alex Bahdanovich
Writer, author, wordsmith -- this tech enthusiast enjoys Starbucks, good reads, and golden retrievers.


Please enter your comment!
Please enter your name here

Most Popular


Recent Comments

error: Content is protected !!