This is the final update, removed the need for regex in Replace, as that require change in regex, if let say there are extra characters or symbols in the data, and as regex is not that simple, came up with new solution which is simple without the regex.
Transform file.
SplitRowsToNewRows3.transform (5.1 KB)