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.
RELATED ARTICLES

4 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android