James asks how to take 10 years of Checking Data and convert it to a Summary Table with Months going across the top and Years going down the side. James would prefer not to have to add new YEAR and MONTH columns to the original Data. Today, Bill shows us a quick method to make this happen in Episode #1752 solving this in just a few mouse clicks.

[youtube=http://www.youtube.com/watch?v=4IFYb2gyX_U]

"Excel 2013 InDepth" - by Bill Jelen

Microsoft 2013 InDepth” – by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013.

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!