Hi, can you please help to create macro, see example below:

In column G, 1st row is contains more than 1 data (343376, 487381), therefore, i need this to split and copy down the same information in another row.
Can you help on this...


Original:

Column A Column B Column C Column D Columm E Column F Column G
Australia A.C.N. GB 0000418 GBC 0001738 343376, 487381
Australia A.P.M. GB 0000418 GBN 0001747 169038

Result:

Column A Column B Column C Column D Columm E Column F Column G
Australia A.C.N. GB 0000418 GBC 0001738 343376
Australia A.C.N. GB 0000418 GBC 0001738 487381
Australia A.P.M. GB 0000418 GBN 0001747 169038