Episode # 705 - Pivoting Time Columns

Change a pivot data set that has quarters going across to rows going down

Sponsored by

Check out this book for more tips
similar to this lesson!

Friday, February 29, 2008

t is difficult to create a pivot table when you have a time component stretching across the columns in your data set. In today's episode, an amazing trick in Excel 2007 to change four quarterly columns into four rows. Episode 705 will show the multiple consolidation ranges trick. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

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!

Watch 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: Excel 2007, Pivot Table, Multiple Consolidation Ranges

Episode # 705 - Pivoting Time Columns

Change a pivot data set that has quarters going across to rows going down

More Excel Video Lessons