data separated by comma

I have some data in a Excel spreadsheet. There are 4 columns and the last column cell has multiple data separated by comma. I want to split them into different cells in the same column but Horizontally. Please see the attached for more details.

Appreciate if you could send me a macro for this.

try

Please Login or Register  to view this content.