Hi guys,

currently I am struggling with below table:
Array
The second column contains a combination of gvkey and year. This ID can occur several times, i.e. gvkey_year 002991_2015 occurs three times, for example.
Now I want to output one FundStage per gvkey_year. For example, if a gvkeyyear has one Later Stage and two Early Stages, a variable should output Early Stage. In total, the FundStage has the characteristics Early, Later and Seed Stage.

Is there a clean way to do this? I have tried various workarounds so far, but they have never been satisfactory.

Thank you very much!

Best regards