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.