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?

Spliting a cell with multiple entries into seperate rows
 

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?
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"melmil" wrote:

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?