Transpose Row and Column Data in Microsoft Excel

If you have ever wanted to swap your data rows and columns in Microsoft Excel, this video is for you. I'm going to show you two different ways to transpose your data. We can use the TRANSPOSE function, or Paste Special method. This basically flips the horizontal and vertical. Kinda like putting your TV on it's side. Kinda. Sorta. We'll also discuss why this is important if you want to get your data into a database like Microsoft Access.

Recommended Course

• Excel Expert 8: https://599cd.com/LX8

Links

• Transpose in Access: https://599cd.com/TransposeData
• FREE Excel Beginner Level 1: https://599cd.com/Free1
• $1 Excel Level 2: https://599cd.com/1Dollar

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

excel 2021, excel 2016, excel 2019, excel 365, microsoft excel, ms excel, ms excel tutorial, #msexcel, #microsoftexcel, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, what is transpose in microsoft excel, TRANSPOSE function, What does it mean to transpose data, ctrl shift enter, rotate data, horizontal, vertical