Traverse each row, perform conditional checks

[sadafzafar]

Hi,

I want to traverse rows which have duplications and extract unique data from their respective columns.

Like the data is in this form

Abc Id	Full/part time	count
C001	Full time	5
C001	Part time	3
C002	Full time	9
C002	Part time	4

I want to convert it like this

Abc Id	Full Time	Part time
C001	5	3
C002	9	4

[#2 · Accepted solution]

@sadafzafar A pivot table will do. See picture.

[#3]

Thanks. It worked