Date

[sohaibj]

I've downloaded data from system in excel which is like this:

Employee Code-Name-Relationship
121-XYZ-EMPLOYEE
BLANK-ABC-SPOUSE
BLANK-DEF-SPOUSE
BLANK-DEF-DAUGHTER
BLANK-GHI-DAUGHTER
BLANK-RST-SON

I want output like this with 1 additional column "Output"
Employee Code-Name-Relationship-Output
121-XYZ-EMPLOYEE-121(EMPLOYEE)
BLANK-ABC-SPOUSE-121(SPOUSE1)
BLANK-DEF-SPOUSE-121(SPOUSE2)
BLANK-DEF-DAUGHTER-121(CHILD1)
BLANK-GHI-DAUGHTER-121(CHILD2)
BLANK-RST-SON-121(CHILD3)

How can I incorporate values in 4th column that is "Output"?
NOTE:
Maximum Spouse would be 4 and maximum children would be 12 in numbers.
I've data on 4,500 rows