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

Daffodill11- thank you so much for your fast response. Favor to ask, would you be able to re-write this Macro with the my data's correct columns? When I was creating my sample data I cut out some of the fields that feed over to my spreadsheet. I was hoping I could figure out the macro to put the correct cells in myself, boy was I wrong All columns are on the new attachment, so column 'N' would be the row to concatenate and 'A' is the duplicate data.

Thanks again,
Tim

Awesome! Thank you so much for your help today

Hi..

Here's another just for fun...

Please Login or Register  to view this content.

Hi, its me again! So this month I changed my report to have less columns however when I tried running the macro that was provided last month it didn't pull the correct information into the correct field. I did change the "N" to "k" but that did not work. So I was wondering if you could help me out again.

I am looking to combine column "K" and then remove the duplicate rows of the same employee. In my example, I have the current data listed and then what I want it to look like after the macro runs.

Thanks for your help! ... again

Hi, I was wondering if anyone would be able to help me with this macro (post on 6/17/15).

Thanks!

Hi, I was wondering if anyone would be able to help me with this macro (post on 6/17/15).

Considering the fact that you didn't even respond to my solution.. in any way.. I think not.

apo, I didn't mean to offend you... sorry...

Daffodill11, thank you for the response and hopefully you had a great time camping. When I plug this macro into my excel document it combines the associate profiles correctly but is not concatenating the correct information. I am needing the "Benefit Plan" column combined, currently this combines the "Benefit Type".

Thanks!
Tim

Originally Posted by daffodil11

Sorry, I've been camping for a while.

I am a little thrown off by your expected results; you show 2 unique employees bu there are actually 4 unique employees in your dataset.

Using ARowbot's code with slight modification:

Please Login or Register  to view this content.

husakt,

If you want the result without deleting original data then use

Please Login or Register  to view this content.

Otherwise

Please Login or Register  to view this content.

Doesn't need to sort the data before you run.

Thank you everyone for your responses, I was able to get that last one to work! Thanks again!

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.