Two Ways to Transpose Excel Data

There are at least Two Ways to turn an Excel data set "on its side." Changing from a " row based" orientation to a "column based" orientation or vice-versa.

In this lesson - Using Excel 2010 for the first time - I demonstrate how to use:
1) Copy - Paste Special - Transpose - great for quickly restructuring your data.
2) The TRANSPOSE Function which is an ARRAY Function

I find that many of my clients and viewers are now familiar with Copy - Paste Special - Transpose. I really like the new "Live Preview" tool for paste Special in Excel 2010!

The only "drawback" with this method is that it does not preserve a "link to" the original cells. Not a major drawback considering that it does preserve the Functions correctly.

With the TRANSPOSE Function - which is an ARRAY Function - you are able to maintain a link to the source data - as long as you do not delete it!

ARRAY Functions are powerful - and easy to use provided you understand the several "got'chas" involved.

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to preview all of the resources that I offer you.

Danny Rocks
The Company Rocks

Category:

Education

Tags:

• Excel Data
• Paste Special Transpose
• Array Functions in Excel
• Transpose Function
• software
• tutorial
• Computer Software
• Office
• Microsoft Excel
• Microsoft Office
• Management
• Training
• Business
• Information
• Technology

[puppy482]

Thanks for the help :)

[DannyRocksExcels]

@puppy482

My pleasure. Thanks for adding your comment.

Danny Rocks

The Company Rocks

[johnjoliver]

Danny: How about transposing data from one workbook (jan data to dec data over columns) to another (jan data to dec data over rows) however maintaining a link to the original workbook. only the column letter needs to be changed on each row.

[DannyRocksExcels]

@johnjoliver

I don't see any reason why that would not work.

Re: Links - They are easily broken. My suggestion is to keep the two workbooks that are "linked" in the same directory. This is especially important if - for example - you are sharing the workbooks between an office and home computers let's say via a USB Thumb Drive.

Danny Rocks

The Company Rocks

[sharma1amit]

Many thanks for explaining us the transposing function,it is actually very useful

[DannyRocksExcels]

@sharma1amit

My pleasure. I am glad that you enjoyed my tutorial.

Danny Rocks

The Company Rocks

[DannyRocksExcels]

@digitaldeziner

Thank you for writing to me. I am pleased that I could help you.

Danny Rocks

The Company Rocks

[digitaldeziner]

Thanks, it is very helpful. And your teaching method is very easy to understand and learn. Thanks again.