Create a specifed number of duplicates

  • Hey guys,


    I've a list of names and a number next to them, I need to essentially expand the list with that number of duplicate names, ie, if my list is:


    NameEntries
    Joe Bloggs4
    Jane Doe2


    I'd then like to end up with:


    Name
    Joe Bloggs
    Joe Bloggs
    Joe Bloggs
    Joe Bloggs
    Jane Doe
    Jane Doe


    Is there anyway to do this?


    Thanks!

  • It can be done with a VBA macro...

    If I've been helpful, let me know. If I haven't, let me know that too.