Is there a way to separate a column using Text to column (b with
multiple data in each row) and add content of another column i.e
separate b to 52 1222; 52 1442; 52 1477...?

A B
52 1222, 1442, 1477, 1722, 1777
52 1232, 1284, 127, 13, 131243, 13173333, 1322, 1341,
becomes
C D
521222 521442

Thanks for your assistance.