dear all,
i don't know how can i add command to merge column in B1 if text duplicate. please suggest to me. i add picture at this discuss.
at this below i want to merge head1 in column1,2 (aaa,bbb) / merge head2 in column 3,4,5 (ccc,ddd,eee)
head1 head1 head2 head2 head2
aaa bbb ccc ddd eee
row1 xx xx xx xx xx
Regard,
Moo
pic1.png (14.56 KB)