+ Reply to Thread
Results 1 to 2 of 2

Merging Duplicate Entries

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    1

    Red face Merging Duplicate Entries

    Hello, everyone!

    I'm working on a massive file that I need to consolidate.

    Is there a formula or a code that will help me merge duplicate entries? I've tried codes and formulas that leave blank cells after the first value but this still means I have to manually merge the topmost value with the remaining blank/duplicate cells.

    Excel problem.jpg

    Thank you!

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Merging Duplicate Entries

    From what you have displayed, a Pivot Table is what you need!

    Do you know how to set up a Pivot Table? If not, the link below may help.

    http://www.contextures.com/CreatePivotTable_2007.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Remove duplicate entries when merging 2 worksheets based on certain criterias
    By zicitron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2013, 06:07 AM
  2. Replies: 0
    Last Post: 06-14-2012, 12:38 PM
  3. Replies: 0
    Last Post: 09-18-2011, 06:48 PM
  4. Need help removing entries, without merging filed
    By myepst in forum Excel General
    Replies: 1
    Last Post: 06-21-2011, 04:31 PM
  5. Duplicate Entries into List of Unique Entries
    By MjRmatt in forum Excel General
    Replies: 1
    Last Post: 08-18-2010, 11:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1