Learn Excel Episode 493: Non-Pivotable Data

Posted in Companies, Podcasts on July 07, 2008


Learn Excel Episode 493: Non-Pivotable Data

In just about every pivot table tutorial, the writer tells you to start with a nice clean transactional data set. No blank rows, no blank columns, and no months going across the columns. David from Pennsylvania writes in to ask what to do if your dataset already is in a table – with headings in the rows and columns. In Episode 493 I borrow a trick from Mike Alexander to solve this problem and make your dataset appropriate for use in a pivot table.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel