Hello,

I am using Excel 2010.

I have been trying to solve this for a while. I have seen a few similar posts, and I have been trying to use the transpose function, but I'm stuck.

I am trying to group rows together based on common values, as in the before and after examples below.

As you can see, the text in bold shows the rows where there are duplicate values, based on both the Client the Date columns. I am trying to group these together, so they appear on one line, as in the second table.

Before :

Client Code1 Code2 Code3 Code4 Date
24435 X2 22/03/2012
24436 D9 05/03/2012
21546 S3 23/04/2012
21546 E1 23/04/2012
21546 Z5 23/04/2012
21546 Q1 02/06/2012
24387 S1 01/05/2012


After :

Client Code1 Code2 Code3 Code4 Date
24435 X2 22/03/2012
24436 D9 05/03/2012
21546 S3 E1 Z5 23/04/2012
21546 Q1 02/06/2012
24387 S1 01/05/2012


Any coding help greatly appreciated!

Thanks

Jim