Monday, 20 February 2012

How to transpose row data to column data in Excel

Say you have a row of data, and you want to lay it out vertically as a column instead, then you can simply select the row, copy it to the clipboard, and then using Microsoft Excel, from the paste special menu, select the Transpose option...

image

No comments:

Post a Comment

Android mediaserver process killing battery life

If this happens to you, then do the following Force stop on Settings, Applications, All, Media Storage. Clear Cache and Clear Data, fo...