Need to merge variable number of cells into one single cell based on criteria

Here’s an example of my data:
A B
1 110 AAAAAAA
2 220 BBBBBBBB
3 330 CCCCCCCC
4 330 DDDDDDD
5 330 EEEEEEEEE
6 440 FFFFFFFFF
7 440 GGGGGGG
8 550 HHHHHHH

I need your help to figure out how to merge the above data to look like this in new blank worksheet using a VBA macro:
A B
1 110 AAAAAAA
2 220 BBBBBBBB
3 330 CCCCCCCC
DDDDDDD
EEEEEEEE
4 440 FFFFFFFFF
GGGGGGG
5 550 HHHHHHH

Thanks for your help in advance.