Forum Discussion

Pro-Pix's avatar
Pro-Pix
Copper Contributor
May 19, 2022

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!

excel
Formulas and Functions

1 Reply

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 19, 2022

    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.

     

     

Resources