Excel Tutorials

Some Excel users have the habit of giving their column headings the dual roles of label and data. For example, they'll call their columns January, February, March, etc. Unfortunaely, this causes a whole host of problems when trying to analyze the data. The video linked below will show you how to easily transpose these datasets to convert these month names into a single column called month.

http://www.datapigtechnologies.com/flashfiles/Transposetables.html

Posted by Mike Alexander @ 5:48 PM