Text to Column function but for rows?

[Pro-Pix]

Hi

Is there a way I can split the data from this one cell into separate rows? Like how Text to Columns would work but horizontally instead of vertically?

Thanks in advance!

[#2]

@Pro-Pix If you happen to be an Insider / beta user you could use the TEXTSPLIT function, using CHAR(10) as the row_delimiter (picture)

Otherwise, do text to columns with Ctrl-J (i.e. a line feed) as the delimiter and use Copy/Paste special/Transpose to paste the row range to a column range.