Split Delimited Data in Columns into New Rows and keep all other data

May I know if you are able to open the attached excel file testdatabase.xlsm?
The macro "replicate data" does exactly what I want, just that it now only works on column B.
I would like it to do the same for Column C, D, E (splitting by delimiter) until the last column (which in this case is column P) that has data in it.