Spliting a cell with multiple entries into seperate rows

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?
 
P

PJFry

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top