I already posted about an Excel Macro in this forum, but this isn't really a duplicate post. I need 2 more macros that are really simple. I have VB coding experience, just no experience coding macros so that's why I'm coping out and getting help on here. So much faster!!

I need macros to do the following...maybe even ASAP utilities has something built in I don't know.

1) If I have a list of names I need to create an index. Let's say the sheet has (each value in it's own column)...

DAVID
DAVID
JOSH
JOSH
SUE

I need it to be

DAVID, 1
DAVID, 2
JOSH, 1
JOSH, 2
SUE, 1

Simple right? LOL

2) I have another sheet that looks like this...

DAVID 2020
2030
2040

But i need it to look like this

DAVID 2020
DAVID 2030
DAVID 2040

Basically just fill in the blanks.

Any help is appreciated!