Delete Duplicates and Concatenate Unique Cells

Hello,
This is my first post here - I have been searching around for quite a while for a solution, and I have found posts that are close, but because I don't know VB I am unable to modify them to work for my exact needs.

What I need is like this: http://www.excelforum.com/excel-prog...nd-delete.html
and
http://www.excelforum.com/excel-work...en-delete.html

Here's my data (I also attached a worksheet):
What I HAVE:
Term POS1 POS2 POS3 POS4 POS5 POS6
find NUM
fun ROY NNP
hello NN VB
hello NN JJ
try JJ
try NN


WHAT I WANT:
Term POS1
find NUM
fun ROY NNP
hello NN VB JJ
try JJ NN



The data is words with their part of speech labels, so I only want one entry per word, but need to concatenate the unique part of speech labels with each word.

I hope that makes sense - I would appreciate your help!

Thank you ,
Nathan

Select a cell in the table. From the Data tab select "Remove Duplicates" for Column A

Not sure what you mean by the rest

Yes, it is a little more complex than that.
What I have is two identical terms with extra columns that have unique data that I want to concatenate.



For example:
hello JJ VB
hello NN ROY VB

Would become:
hello JJ VB NN ROY

Is that a little clearer?

I found code that comes close to what I need for two columns, but I am not sure how to modify it for say, 5 or 6 columns (or however many I need) as well as remove duplicates. Can someone help?

Please Login or Register  to view this content.

Here is another approach. Puts results in K1.

Please Login or Register  to view this content.

EDIT: amended slightly, ignore my previous comment about 100 limit, completely wrong!

Maybe this gives the same result:

Please Login or Register  to view this content.