Combine Data Cells with Same Column Identifier

[mperillo]

Would anyone be able to post a formula that would obtain the following results:

Before: Two Columns, 'A' having the Identifer and 'B' the date and 'C' is the data...

A B C
1001 3/31/2005something
1001 3/31/2005is
1001 3/31/2005blue
2005 4/1/2005 everyone
2005 4/1/2005 smile
3004 4/2/2005 look
3004 4/3/2005 both
3004 4/3/2005 ways

And make it look like this:

A B C
1001 3/31/2005something is blue
2005 4/1/2005 everyone smile
3004 4/2/2005 look
3004 4/3/2005 both ways



Thanks!

[theDude]

A macro can do what you want…

Thanks to Dave Peterson for providing original code in this thread:
http://www.excelforum.com/showthread.php?t=349045
which I modified for your example:

Please Login or Register  to view this content.

Hope this helps,
theDude