I have a list in excell that has a name, then below it a random number of blank fields then another name. Anyone know if I could build a macro to fill in those blanks with the first name?
Looks like this:
John Doe
Jane Doe
Need to look like:
John Doe
John Doe
John Doe
John Doe
John Doe
John Doe
Jane Doe
Any shortcut would be appreciated as this is a 10,000+ line spreadsheet!
Thanks!
Looks like this:
John Doe
Jane Doe
Need to look like:
John Doe
John Doe
John Doe
John Doe
John Doe
John Doe
Jane Doe
Any shortcut would be appreciated as this is a 10,000+ line spreadsheet!
Thanks!