Excel Power Tips - Merge (Deduplicate) Like Records

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,446
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 13, 2010

When using an MS Excel worksheet as if it were a database table, in many cases you will want to have only one record per unique identifier, such as Customer ID, Order ID, or customer name. However, at the same time, you may have one field in the record that contains data (e.g., Revenue) that needs to be added (summed) if you merge the records. Here is how to do this using Pivot Tables.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • how can you select classic pivot table for a mac?

  • oh yeah!

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more