How to Use Excel’s Transpose and Text to Columns Tools to Reorganize Your Data

This video lesson is in response to a viewer’s request. The information that he gets comes from a mainframe computer and the orientation of the data is horizontal (going left-to-right across columns. He wants to be able to reorganize this data to show it vertically (from top-to-bottom in rows. I use Excel’s Transpose tool to show him how to do this.

I also demonstrate an extremely useful Excel Tool – Text to Columns – to break apart an address block (City, State, Postal Code) into discrete fields – to help you to manage a mail merge or to sort and filter by State or by Postal Code.

(Note: Somehow this lesson “got lost” as I was reorganizing my website. So, I apologize in advance if you already viewed this lesson.)

If you enjoyed this lesson, I invite you to visit my online bookstore to shop for my DVD, “The 50 Best Tips for Excel 2007.” It is on sale now!

You can watch this Excel Video Lesson on YouTube – vist my channel – DannyRocksExcels

Related Videos

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Comments

  1. Keep posting stuff like this i really like it

Trackbacks

  1. […] How to Use Excel’s Transpose and Text to Columns Tools to Reorganize Your Data […]

Speak Your Mind

*