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

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

[Subjectmoney]

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]

Hey guys please comment on this video. Any interactions such as commenting, rating, sharing and adding to your favorites increases our ranking on Youtube

[conorfarley]

if the options under "operation" in pastespecial are faded/nonfunctioning, includingtranspose, any idea why this may be?

[markhintz]

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"

[Halfmoon]

Awesome stuff! You just saved me a ton of very boring work ! Many thanks !

[RC-lwlw]

Thank you for posting this. Solved my question!

[MrShankiye]

thank u so much for sharing this tutorial.

[mikhasutin]

Thank you for sharing the video. Useful video

[HellaBass]

Amazing I never new that was there, great nugget

[june]

Thanks this is really help me to write my assigment

[Ulujmf]

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

[Sandwichplss]

Is there a way to do this without messing up my formulas?

[tansiewhongkpm-guru]

Thank you so much for this! I almost want to do it manually

[issacnewton]

how to do it flip table without transposing?

[juliuscezardomingo]

Hey pal" thank you for sharing this video.