Create a Unique List of Customers with a Pivot Table

February 02, 2023 - by Bill Jelen

Problem: I need to create a unique list of customers from a large list.

Strategy: You can build a pivot table report with Customer in the Row area of the layout. Because the pivot table creates a summary report, the first column of the table will include the unique list of customers. Here’s what you do:

1. Select Insert, Pivot Table. Click OK in the Create PivotTable dialog.
2. Click the Customer field in the PivotTable Field List dialog.

That’s it. You are done. You can now copy the customers from column A of the new sheet and use Paste Values to put the unique list of customers wherever you need it.

The pivot table heading in A3 says Row Labels. The items in A4:A12 are customer names. — Figure 996. Four clicks to create a unique list of customers.

This article is an excerpt from Power Excel With MrExcel

Title photo by Patrick Tomasso on Unsplash