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 – shop.thecompanyrocks.com – to preview all of the resources that I offer you. Danny Rocks The Company Rocks