Philipp Kowalski is a self-taught Excel-lover, project manager and blog-owner. Besides developing "beautiful" solutions in MS' premier spreadsheet tool, he loves his fiance, his cats and surfing the net. He is CEO and owner of Inservo IT, the company behind Excel-King. He's also available on Twitter and YouTube. If you like this website, please leave a comment. If you want to know more visit the forums or look into the about section of this website.

Home Tips & TricksVerticalizing your tables

Error

Error loading Modules:

Verticalizing your tables

Written by inservo | 10 May 2009

font size: decrease font size increase font size
Bookmark this page
Rate this article
Related content

Do you know that problem? You have set up a table like the one showing below but half way through you think, that it would better to have the information "verticalized".

This means that the headings should be in row A and all the data should not be in horizontal orientation but top to bottom.

Table with horizontal oriented data

Well, that is quite easy. Select all your data with your mouse or the keyboard and copy it by chosing Edit > copy or using the keyboard shortcut CTRL+C which should mark the selection with the "marching ants". Then right-click on cell A4 and choose paste special.

Paste special

In the upcoming menu check the Transpose box and voilà there you have your cells "verticalized".

Transposing cells

The one thing left to do is to delete the horizontal arranged data by selecting the "old rows" and chosing Delete from the right-click context menu.

Transposed data

Unfortunately in MSXL 2003 it is not possible to overwrite the original data by transposed information.

Discuss this blog post in the forums (click the blue button)

Written on Sunday, 10 May 2009 00:00 by Administrator

Viewed 285 times so far.
Like this? Tweet it to your followers!

Published in Subscribe to the RSS feed of Blog Topics Blog Topics / Subscribe to the RSS feed of Tips and Tricks Tips and Tricks

Like this? Let your friends know now!

Rate this article

(1 vote)

Latest 'tweets' from Phil Kowalski

dashboard reporting http://bit.ly/eSiM68 . Dashboard Financial Reporting for Board Members Link Wednesday, 30 March 2011 16:00
! http://bit.ly/fZZSOI Display hidden data in an Excel chart chart excel Link Wednesday, 30 March 2011 06:00
Calculate the Coefficient of Variation in Excel statistics excel http://bit.ly/h6JrOe :P Link Wednesday, 30 March 2011 01:00
Excel - Combine Data From 2 Different Spreadsheets With a VLookup vlookup :O http://bit.ly/gFK5YH Link Tuesday, 29 March 2011 15:40
Undo and Redo in Microsoft Excel 2007 windows excel :) http://bit.ly/eM064Y Link Tuesday, 29 March 2011 14:00