How to Make a Pivot Table in Excel 2010

I was recently downloading a lot of CSV orders from a customer, which I then combined into one file using the CSV file combination process in this article. However, all of the data from those orders was itemized, and our production team needed each item combined into one line so that they knew how much of each item to produce. Manually going through thousands of lines of data, even when it is sorted, is a hassle. Pivot tables provide the perfect solution to this problem.

 

Step 1: Open your Excel file in Excel 2010.

Step 2: Highlight all of the data that you want to include in the pivot table. Don’t highlight any column headings, as that will complicate the process.

Highlight the data you want to include in the pivot table

 

Step 3: Click “Insert” at the top of the window, click “Pivot Table,” then click “Pivot Table” again.

Select pivot table from the Insert menu

 

Step 4: Click the “OK” button in the pop-up window to create the pivot table on a new sheet.

Create a new sheet for your pivot table

 

Step 5: Check the box to the left of each column at the right side of the window. Each value will be combined into one line, showing the total associated quantity for that value.

Select the fields to include in the pivot table                  View your completed pivot table

Share this...Share on FacebookTweet about this on TwitterShare on Google+Pin on PinterestShare on TumblrShare on RedditEmail this to someone