Merging multiple Sub Numbers into a Cell

Hello All,

Could someone help me with below:

As i am working on consolidating the numbers manually, whether will it possible for making this automatic.

In Column "A" I have Multiple Duplicate Numbers and followed by the Different Sub Numbers in Column "B". Here i need to manually need to consolidate each number in Column "E" and this is followed by the multipl Sub Numbers in Column "F" in single cell with comma separated to each sub numbers.

Example:

Before Consolidation : (Column "A" & "B")

Number Sub Number
200400001 5
200400001 8
200400001 9
200400001 11
200400001 55
200400001 A
200400001 C
200400001 D
200400001 8
200400001 9


After Consolidation : (Column "E" & "F")
Number Sub Number
200400001 5,8,9,11,55,A,C,D,8,9

Instead of doing this manually can we have the VBA to auto consolidate this numbers.

Here by i am attaching sample file.