Format a filtered result set

I have attached a snip for review. I apply a filter to my column and when I get results they look like the attached file. I want to keep my results but would like them listed as A1, A2, A3 not as the results show A129, A153, A169. If I remove the filter - obviously my result set that I need is not there.
I am sending to someone and would rather it look clean, Thanks in advance and included is the attachment
Looks like this
                                 A                     B
1                            client                Group
129                        Jim                     A
153                       Bob                     B
169                        John                   C
So this is how the filtered portion looks
Should be
                                 A                     B
1                            client                Group
2                             Jim                     A
3                            Bob                     B
4                           John                   C
Filtered_format_result_set.docx