Hi everyone. I have browsed through the posts, but I can't seem to find what I'm looking for. I'm new to Excel, sort of. I've done basic data entry before, but now I have a new problem that I can't seem to solve on my own. I have a column with information - the same information is in each row, only it's different information. That even sounded complicated to me. For example, I have the name, address and phone number in row one. In row two, I have a different name, address and telephone number. Again, in row three, it's yet a different name, address and phone number. But all of this is is the same column - column A. My question is this: Is there a way to separate the addresses and phone numbers, and put them in different columns? So for instance, my outcome would be: Row 1, column 1; Name. Row 1, column 2; address. Row 1, column 3; phone. And then repeat that with each row. Let me try a picture because this is even hard for myself to comprehend, even though I have a clear picture of it in my head.
What I have: What I'm looking to do:
Company ABC Company ABC 123 Snail Rd. Alphabet, NY 12345 (555) 555-5555
123 Snail Rd.
Alphabet, NY 12345
(555) 555-5555
I hope that makes better sense. I don't know if there's a term for it or if I have to do each one individually, but any relevant help would be wonderful. Thank you so much for taking the time to read this.
Michele
Bookmarks