Use the Transpose Feature to Change the Orientation of Data Imported into Excel

I am working through the special requests that viewers have sent me. In this lesson, I show you how to:

• Use Data – Get External Data – to import a simple delimited text file.
• Use Copy – Paste Special – Transpose – to make a copy of the imported data that is now “vertically oriented.” i.e. The field entries run down the column rather than across the rows.
• Use the Data – Text-to-Columns feature to break an “address block” (City, State, Zip Code) that is one cell into three distinct cells. This is a terrific time saver!

Now available for purchase: My DVD “The 50 Best Tips, Tricks, and Techniques for Excel 2007”

Over 5 1/2 hours of training. Each video lesson focuses on one tip and averages 6 minutes.

Now available from the online store at www.thecompanyrocks.com

Related Videos

• Visit my Index of Excel Training Videos – to find the specific “free” video lesson that you want