A blog for listing new Microsoft Excel tutorials.
Thursday, July 28, 2005Transposing an Entire Dataset at OnceSome 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
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. This weblog is in no way associated with Microsoft. | |
SubscribeExcel Tutorial LinksExcel Templates
Archives
Syndicate |