My data has multiple rows in one cell seperated by carriage return. I want to put each line of the cell into a new column. I have tried using Text to Columns with the Other Option under Delimiters being Ctrl + J. It only shows the first line of the cell. The subsequent lines of each cell are deleted.

For example

UNIT 1/1 SAMANTHA CRT
BOXFIELD
MELBOURNE

becomes

UNIT 1/1 SAMANTHA CRT

BOXFIELD & MELBOURNE just disappear completely instead of moving to next column.