Forum Discussion
Text to Column function but for rows?
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!
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.