Spliting a cell with multiple entries into seperate rows

  • Thread starter Thread starter melmil
  • Start date Start date
M

melmil

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?
 
If the text to columns will work, you can always do that first, and then
Copy-Paste Special and Transpose the array into rows. That would accomplish
what you need.

Is this something you be doing often, or is this ad-hoc?
 
Back
Top