Turning A Stacked List into workable data
- by BoSox
In Excel I have a list of names that in the cell appear stacked, and I want each name in its own column. I was thinking Python may be a good way to do this?
Example:
Joe Smith
John Hawk
Mike Green
Lauren Smith
One cell will look exactly like that, with each name on its line within the cell but all of the names contained in the cell. I have 50 cells each with 1-20 stacked names and I want to put each name in its own cell on a given row. So, in my example all of those names would occupy the same row but each would have their own column.
Any ideas?