Flatten data in 3 column with a unique ID in one column

Hello I'm a newbie in excel-vba and working on a dataset which has repetitive data in multiple columns with unique values in one column. I was wondering if there is a way I could flatten my dataset.

Example

ID ID2 Name
1234 123,234 ABC DTER; CD EF; FGH EHGD; AB TEW
2345 1234,4532,553 RERT, ERREW

to be displayed as
ID ID2 Name
1234 123 ABC DTER
1234 234 CD EF
1234 FGH EHGD
1234 AB TEW
2345 1234 RERT
2345 4532 ERREW
2345 553

Any help is appreciated!