Hi there,

You can first add a column before the name column, enter the formula in the top cell of the added column: =COUNTIF($B$1:$B1,B1)

Note: B1 is the top cell of the name column. You should leave the dollar signs the way they are.

After entering the formula, drag the fill handle down to the cells below.



If you need to combine the both columns, you can use the formula in the cell C1: =CONCATENATE(A1," ",B1)



Or you can use Kutools for Excel's Combine rows, columns, or cells without losing data feature:




If you have any questions, please don't hesitate to ask me.

Amanda