I have an Excel table like this

Now from the second column, I want to split them into small substring and group them in each ID group, like this

Please let me know how I can do that programmatically.

Since I’m new from Excel, I have tried this but it does not work: https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7