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...
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?
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?
I can not download your file because of network.
I think it may easier to understand your request if you provide some foke datas in text instead of screenshot and desired output based on the source table.
I think it may easier to understand your request if you provide some foke datas in text instead of screenshot and desired output based on the source table.