Transpose Excel Data From Rows To Columns In A Flash!


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.

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.

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts