Hi guys,
I need help with sorting data in the below table. As you can see, the same person no (62) has two different cost center (1210 & 1220). I want a new table which basically mentions the first date of the cost center and the last date of the cost center as shown below:
Current table:
Required Table:
I need help with sorting data in the below table. As you can see, the same person no (62) has two different cost center (1210 & 1220). I want a new table which basically mentions the first date of the cost center and the last date of the cost center as shown below:
Current table:
Required Table: