Forum Discussion
Getting copy/paste into excel to populate vertically
I have 5,000 names separated by commas in a Word document. Transferring them into Excel they populate automatically along the top line, horizontally with the letters. I need them to populate vertical...
I assume that each name sits in its own cell, let's say from A1 to GJH1. That would be 5000 columns wide.
Step 1: Select that range by selecting A1, then press shift-cmd-right_arrow
Step 2: Ctrl-C to copy
Step 3: Select A2, press the 'down arrow' on the right-hand side of the Paste icon on the Home ribbon
Step 4: Transpose
Step 5: Delete row 1
- Thank you for your reply. I was able to figure it out and now I have a new problem. In the last week I have deleted and added names to the list. When I sort them alphabetically, I have two lists... the orginal list now alphabetized and the new names below that last also alphabetized. How do I get the two lists to merge into one list? I've tried everything and it won't merge into one. Any suggestions? very frustrating. Thank you. AmericanIndependentJournalist AT gmail DOT com Dillon Woods
Sorry but I don't understand the question. Can you send your file to me in a private message? Click on my avatar and select Message.
- Thank you for your reply. I have made a PDF document with screen shots to show you what is going on and uploaded it to my OneDrive at this link:
https://1drv.ms/b/c/080681367835d8cc/EUP6AAnIpbtAoQscLUA7qVABgCbWd0DZQwBi9cpwmOw_hg?e=ARAUl6
Here is the text of the PDF:
I had almost 6,000 names in a word document and all the names were separated by a comma.
I copied all the names into line number 1 of my excel document – which put them on a horizonal line. I followed your instructions on how to make them appear vertically so each name would have a number, instead of having a letter of the alphabet (along the horizontal line).
MY NEW EXCEL PROBLEM:
After moving the names along the numbered, vertical lines I have added some names and deleted duplicates during the last week. I just noticed they are all not sorting as one group.
For some reason, I now have two groups of names – the original very long list of names and the new, smaller batch of names. I try to “sort” them by highlighting the long list of names and they will not merge.
The total number of names on the list is 5,925 and the last name at that number is Xavier.
The original list of names ends with Zuckerberg at number 5841 and the new names starts with Al Pacino at 5842.
On the very first line where I originally had copied all the list of names from Word, I saw this little arrow and I clicked it to see what it was and it had all the names from the original list (ending with Zuckerberg) and not the new addition of names. So I think this is why it is not sorting the new names. Somehow, the new names need to be on this list for it to sort all of them alphabetically?
How do I get all these names to be one list, in alphabetical order?
