Turning A Stacked List into workable data
Posted
by
BoSox
on Stack Overflow
See other posts from Stack Overflow
or by BoSox
Published on 2012-10-05T15:34:18Z
Indexed on
2012/10/05
15:37 UTC
Read the original article
Hit count: 271
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?
© Stack Overflow or respective owner
