Merge a series of rows with the same ID reference to a single row
automatically using VBA.

For example:

ID Name Amount
200 Majirius 120
200 Majirius 100
200 Majirius 200
300 Bonaventure 200
300 Bonaventure 120
400 Louis 100
500 Bernard 50
500 Bernard 50
500 Bernard 100

Should become:

ID Name Amount1 Amount2 Amount 3
200 Majirius 120 100
200
300 Bonaventure 200 120
400 Louis 100
500 Bernard 50 50
50

Thank you in advance for helping me post this problem.