Hi everyone this is my first post here. I sort of have a problem

Column A Project names ex; A1 Chocolate Factory, A2 Hat Factory A3 Chocolate Factory, (with lots of duplicates)
Column B Stage of project ex; B1 Stage 2, B2 Stage 1, B3 Stage 2.

What i already have succeded in doing is to erease all duplicates from Column A. And entered these into Column C.

Now however, i would like to remove duplicates into column C, but with included Stage of project, and preferably merge into one Cell.


So for Column C in this case i would Get
C1, Chocolate Factory Stage 2
C2, Hat factory Stage 1

I know that i Could Merge Column A with B and then remove the duplicates, but i need this to work without further steps.

Regards from Sweden