Team could you please help me out with the below problem
Eg: I have the below table
Company ID DESIGNATION
ABC 1 Employee
ABC 1 Supervisor
ABC 2 Manager
I wanted the data to be concatenated as below in one variable, the new_var should have id concatenated with designation, can you please help me out
Company ID DESIGNATION New_var
ABC 1 Employee 1-Employee, 1-Supervisor, 2-Manager
... View more