I have a problem trying to format some data. I have the following data...

A B C D E F
add1 cmp1 add2 cmp2 cmp3 cmp4

A-F are columns
add1-2 is to be manipulated
cmp1-4 is data to be compared

Here is what i need to do. I need to compare cmp1-4 to each row. If the
data compares for cmp1-4 i need to add column C (add2) to the matching row,
and add 1 to the value in column A.

Example:
A B C D E F
1 x c2 y z a
1 x c3 y z a
1 y c4 y z a
1 x c5 y y a
1 x c6 y y a

Result:
A B C D E F
2 x c2,c3 y z a
1 y c4 y z a
2 x c5,c6 y y a

Can someone help me with this?

Thanks.

dm.