• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » Transpose Excel Data From Rows To Columns In A Flash!

Transpose Excel Data From Rows To Columns In A Flash!

March 19, 2011 by Barbara

This really is a time saver and well impresses colleagues if you needs to change around the look of an Excel sheet right in fromt of someones eyes!

You might want to change around the layout of your Excel sheet but you have already entered in loads of your data, or the data you have received just isn’t in the payout you want, there’s no need to rekey all that data- no way!, Excel will flippity flop your data from rows to columns or columns to rows straight away.

Pin it! Share on Facebook

In the example here I have entered the Name and Weekly Sales Of Widgets_1 , but I think that the data would look better swapped around with the names along the top in the column area and the Weekly Sales down the columns as the number of weeks increases it will be easier to read then scrolling across the screen.

Give this one a go and tell us how you get on.

Filed Under: Excel Tips& Tricks

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2022 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

Share
Additional Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Excel Jobs

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts



  • Privacy Policy