Switching Data Around in Excel

Have you got some data in an Excel worksheet that you have going across in a row but would prefer to have in a column or vice versa? Many times I have seen people copy cells one by one into the place that they want the data and in some cases I’ve seen people retyping the data.

Quite often the data has come across like this because it has been imported from a database, text or csv file.

However, it is easy to fix and this is possible using the transpose feature in Paste Special. Here in this video tutorial you will see how to do this and how easy it is.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Office 2010 and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s