HomeОбразованиеRelated VideosMore From: Subjectmoney

Excel Tutorial: How to Transpose a Table in Excel Change From Verticle to Horizontal 2010, 2013

157 ratings | 26319 views
http://www.excelfornoobs.com I this quick Excel Tips tutorial I show you how to use the clipboard and paste special feature to transpose a table in Excel. This is useful when you need to transpose a vertical table to a horizontal table or transpose a horizontal table to a vertical table. This Excel tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013 Transpose table orientation in Excel Be sure to Rate, and share our videos and don't forget to subscribe. Please also visit our website at http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=Wow_Nb3a0V4
Html code for embedding videos on your blog
Text Comments (17)
Mark Hintz (3 months ago)
Ugh..That's not a table, it's tabular in format but in Excel a "Table" is actually not the same as a "Range" which is what you are using. The Tables have tools and specific default actions and other differences than a range. How do I make a horizontal "Table", not horizontal "Text in a tabular layout"
PAWAN OfficialMail (4 months ago)
Ryan Clark (8 months ago)
Thank you for posting this. Solved my question!
Msd AMD (1 year ago)
great help. many thanks
Gutter1357 (1 year ago)
Thank you!
Amal Saweris (1 year ago)
Thank you :)
Ulujmf (2 years ago)
how do you transpose 4 numbers for example: 4 number in cells A1, A2, B1, B2 to 4 number in cells A1, B1, C1, D1 format
Mario King (2 years ago)
16phalle (2 years ago)
and thank you for saving my day!!!!
Daniel Smith (2 years ago)
sniff (2 years ago)
awesome thank u sir
Matatahakuna (2 years ago)
Shashank Bangalore (3 years ago)
thank u so much for sharing this tutorial.
Julius Cezar Domingo (3 years ago)
Hey pal" thank you for sharing this video.
conor farley (5 years ago)
if the options under "operation" in pastespecial are faded/nonfunctioning, includingtranspose, any idea why this may be?
Subjectmoney (5 years ago)
If my free tutorials have helped you in any way please repay by liking, commenting, sharing and saving the videos to your favorites. Your interaction improves the search ranking of my tutorials which motivates me to keep making more. Thanks for the support!
Subjectmoney (5 years ago)
Hey guys please comment on this video. Any interactions such as commenting, rating, sharing and adding to your favorites increases our ranking on Youtube

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.