August 29, 2013

Transpose a Table in Excel 2010

Many times when creating a table in excel and trying to decide the best way to present your data, it would be easier to transpose your table rather than recreating a second table.  Good news is that you can there is no need to do double the work.  Just select and copy the table you would like to transpose. Then select the place on your spreadsheet you would like your second table to appear. Next click on the Home tab, and in the Clipboard group select the drop down arrow underneath the Paste option and when you hoover over the 3rd icon on the 2nd row you will see it says Transpose. Once you click this icon you will see your transposed table.

No comments:

Post a Comment