Hello all! Thanks in advance for your time ![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have been trying to take a very large excel list such as:
Brown, Angela; Lex, Amy; Jones, Cheryl; Loria, Patty; .........
and move it to columns in excel. I've tried text to columns, and I can get it split up correctly, then I try to copy and past special : transpose but I'm just not getting the data in a usable way. I tried concatenate to get the data back to one cell but I cannot wrap my mind around how to do this. Any ideas?
THANKS!!
Amy
I have been trying to take a very large excel list such as:
Brown, Angela; Lex, Amy; Jones, Cheryl; Loria, Patty; .........
and move it to columns in excel. I've tried text to columns, and I can get it split up correctly, then I try to copy and past special : transpose but I'm just not getting the data in a usable way. I tried concatenate to get the data back to one cell but I cannot wrap my mind around how to do this. Any ideas?
THANKS!!
Amy