Hi to everyone, I need your help. I have two columns like this:
Col A (table) Col B (name)
1 Jack
1 Jack
1 Jack
1 Jack
2
2
2
2 Ben
3 Ben
3
3
3
... ...
I need to create a new list in which I resume the data like this:
Col A (table) Col B (name)
1 Jack
2 Ben
3 Ben
... ...
So I need to delete duplicates and write 2 new columns in which there are the name of the person and his table. Is it possible? Maybe with a macro?
Thanks for the help