grouping data

[deepika.nowley]

dear everyone,
I have 3 columns say
colA colB Col C
row1 1 A pen
row2 2 B sit
row3 1 A read

now i want my output to be like

colA colB Col C
row1 1 A pen
row2 read
row3 2 B sit

that is i want to group all the As in the column B and allow it to display
only once for howmany ever rows we have in col C.
The main thing is that these rows get filled from another sheet. therefore
they are dynamic, i may have any number of rows in this sheet.
I want to do this kind of grouping inside a macro. kindly help

[robert111]

It is not clear what you require, do you want:

1......a.......read
................sit
................stand
1......b.......cat
.................dog
2......a.......push
................pull
................lift
................drop

[deepika.nowley]

i want it like

1..............a...............read
.................................sit
..................................stand
2...............b.............. cat
.................................dog


wehn col A and Col B are the same i want to merge A and then merge B so that it appears as a whole single cell A and a single cell B to the right of which is present many cells like read then sit and then stand vertically

It is not clear what you require, do you want:

1......a.......read
................sit
................stand
1......b.......cat
.................dog
2......a.......push
................pull
................lift
................drop

[robert111]

try this, see attachment.