Episode # 261 - 1 Record on 5 Rows
Sponsored by
Check out this book for more tips
similar to this lesson!
Wednesday, May 24, 2006
Today, we deal with the most annoying dataset - each logical record is spread out over more than one physical row. It is impossible to analyze this data unless you transform it into one row per record. In Episode 261, Bill shows you how to solve this problem.
You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 4 minutes to learn this lesson now with our free video!
Click Play icon to play the video. You might first need to click on the Video to activate Flash player.
Tags/Keywords for this video: Formulas
More Excel Video Lessons
If you like this video, there are hundreds of 2-5 minute videos available here:
- Excel training videos about Charts
- Excel training videos about VBA
- Excel training videos about Pivot Tables
- Excel training videos about Data Analysis
- Excel training videos about Formulas
- Excel training videos about Formatting
- Excel training videos about Printing
- Excel training videos about Excel 2007
- Excel Video Lessons Index
