grouping data

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

Originally Posted by 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

try this, see attachment.