Split Text to Rows
The tool Split Text to Rows allows you to split text contained in the cells of a single column and vertically transpose separated fields on the rows of such column, replicating cells with data that go along with each original cell of the split column in the selected adjacent columns as part of the entire data area.
It is possible to apply one or more delimiters to perform the fields division.
The output will be generated in a new workbook without affecting original data.
This tool works similarly to the one named Transposing Cross Tables