Thread: Spliting a cell with multiple entries into seperate rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
melmil melmil is offline
external usenet poster
  
Posts: 1
Default Spliting a cell with multiple entries into seperate rows
I have a spreadsheet, with multiple entries in one cell. I want to split the
entries, so that they each are seperate rows. I am familar with the text to
column feature, but this would be text to row. Example:

One cell has: 1960
1961
1962
1963

I would like these each of these in a seperate row.

Is this possible?




Reply With QuoteReply With Quote