How to do it in Excel?

@PBKING (1523)
India
June 24, 2017 9:14am CST
Hey Friends, Hope you all doing good.. Is there any Excel expert on mylot? I need your help to learn one thing. I want to copy the text in the blank cells under that cell. As you see in the above image, i want to copy prashant name in blank cells upto Excel text. Then i want to copy excel text in blank cells upto Microsoft name and so on. I need to do this for 10000 names like prashant,excel,microsoft, etc... Do you have any idea about this? How can i do it in one click as it's very time consuming to do it one by one?
2 people like this
1 response
@Nawsheen (28643)
• Mauritius
25 Jun 17
Have you been able to do it?
1 person likes this
@PBKING (1523)
• India
25 Jun 17
Nope.. It's not possible for me to do it for many different words every time
1 person likes this
@Nawsheen (28643)
• Mauritius
26 Jun 17
@PBKING doing this manually will be so time consuming
1 person likes this
@PBKING (1523)
• India
27 Jun 17
@Nawsheen yeah exactly..that's why i want shortcut to do it
1 person likes this