3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)

3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)

 

 

Check out 3 ways to Transpose your data in Excel. These are useful when you want to switch the orientation of your data from columns to rows or vice versa. 

 

I show you how to: 

1. Use a static approach - copy and paste as transpose 
2. Use the Transpose function to rotate data 
   
3. Use a simple formula trick to transpose - this way you can transpose without an array formula and also transpose without copying and pasting. 

Related Topics:

• How to Turn Off GetPivotData for Excel Pivot Tables 
• Create Multiple Pivot Table Reports with Show Report Filter Pages 
• How To Use Slicers in Excel: User Guide for Beginners 
• Intro to Pivot Tables