Results 1 to 18 of 18

Concatenating Rows with Duplicate Data and Removing

Threaded View

  1. #1
    Registered User
    Join Date
    05-21-2015
    Location
    USA
    MS-Off Ver
    MS Office 2013
    Posts
    9

    Concatenating Rows with Duplicate Data and Removing

    Hello,

    First off - I am using 2013 excel and I am trying to combine a rows into one cell while removing the duplicate data. I have attached an example of what I am trying to accomplish here.

    At the top of my spreadsheet I have the current data where there are multiple rows that have the same employee but in column H they have separate benefit plans. What I would like to do is have the system search for the Employee ID number and then combine the different benefit plans. After it combines column H, it can then delete the duplicate rows.

    The yellow highlighted data is what the end results would look like.

    I'm not good at writing Macros so any help would be great!

    Thanks,
    Tim
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-09-2015, 08:30 PM
  2. [SOLVED] Removing Duplicate rows of data
    By dking041966 in forum Excel General
    Replies: 0
    Last Post: 03-26-2015, 11:58 AM
  3. Removing rows of data that include a specific cell of duplicate info...
    By HanTuco in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 05:57 PM
  4. Removing duplicate rows and combining unique data
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2006, 07:10 AM
  5. Replies: 1
    Last Post: 04-01-2005, 07:06 PM

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