i have a list of data with row labels like this:

a c
a x
a n
a y
b c
b x
b n
b y

just want to know the simplest way to add rows c,n for a and b, then delete
rows c and n for a and b, then insert two new rows containing c+n. Tried cut
and paste with xlAdd but this is messy. Also thought of using arrays, but
this could be more long winded while avoiding the problems i am having with
copy/paste.