A pivot table is a merely a summary of data in a format that you can manipulate to suit your needs.  Almost any array of data can be used to create a pivot table, given some simple rules:

• The column labels must be in the first row, and have distinct names
• The data must be in a list format
• There should be no blank rows
• Don’t include subtotals when selecting the data

Note: You can follow along with the how-to by clicking on the following Excel file link: Pivot Table Creation.xls

The pivot table starts with the data in a list format:

To create the pivot table, select Data, then PivotTable and PivotChart Report from the toolbar.  This will open a wizard that will guide you through the setup:

In Step 1, we’ll want to select Microsoft Office Excel list or database and PivotTable. Click Next:

In Step 2, we’ll select the data that we want in the pivot table.  Click the little box next to the Browse button, and select your data:

Step 3 will ask you where to put the pivot table.  You can opt to put it on a separate tab.  In this example, we’ll just insert it in the current sheet:

What you initially wind up with is a blank template, outlined in blue, and a list of the column names from your data list:

We want to sort the data by manager, so click and drag the Manager label from the Pivot Table Field List box to the left column which is labeled Drop Row Fields Here:

Next, we’ll drag the Sales label from the Field List box to the space labeled Drop Data Items Here:

Finally, we’ll drag the Profit label over to the Total column in the pivot table:

Ta-da!  You’ve created a pivot table, and made sense out of a long list of data.  In our next post, we’ll link the pivot table to spreadsheet using the GETPIVOTDATA  formula.

• Low Budget Circumstance has forced my hand, To be a cut price person in a low budget land - from Low Budget, by The Kinks, circa 1979 They say the more things change, the more they stay the same.  I remember when that song came out; we were embroiled in controversy with......
• A Simple Mortgage Amortization Table Kevin over at the No Debt Plan blog recently advised his readers to avoid mortgage accelerator programs like the plague.  He reasoned that you could set up your own mortgage accelerator program by adding 1/12 of a payment as additional principal to each month's payment.  I agree with Kevin. You......
• Excel How-to: The SUMIF Function The SUMIF function is an easy way to get a subtotal of specific data that meets a certain condition, without going through the trouble of producing a Pivot Table.  It's most useful when working with long arrays of diverse data: Note: You can follow along with this how-to by opening......

• ecto Last week the momma found an application for desktop blogging. It's called ecto and is sold by illumineX (who purchased the original company, infinite sushi). It is so much easier to manage this blog, create links, etc. She purchased the program after using the 21-day trial version for only 15......
• The Key to a Successful Blog In the last post, regarding keys to a strong blog, we talked about some of the keys to successful blogging. This is part two in the series about finding your niche and repeating the formula to create successful blogging. We last left you with a list of your best blog......
• Successfully Added ListingKey to Loan Table Prosper's public data does not have a primary key foreign key relationship between the loan and listing table.  This keeps one from being able to correlate loans to listings which prosper does intentionally for privacy reasons. However, the other data in both tables is adequate to match on ~99.8% of the loans.  I......