Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Transposing and Linking.
by Allen Wyatt
(last updated May 5, 2018)
You may already know that you can transpose information by using the Paste Special abilities of Excel. The information that is pasted is not dynamic, however. In some instances it might be nice to have the transposed information always reflect what is in the original, un-transposed information.
Here's a cool way to transpose information and have it linked to the original information:
That's it. You've now got a dynamic transposed table, and any changes you make in the original are automatically reflected in the transposed version.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12614) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Transposing and Linking.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Given a range of cells, you may at some time want to calculate the sum of only the largest values in that range. Here is ...Discover More
If you would like to determine how many instances of a particular word appear within a range of text, there are several ...Discover More
Excel is usually more flexible in what you can reference in formulas than is immediately apparent. This tip examines some ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.