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.

Hello NewYorkVanilla,

On which statement or line does the error occur?

Hi -

Please Login or Register  to view this content.

Thanks for your help.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time

Excel version should not affect this code, it seems to work in 2007