SOLVED

Traverse each row, perform conditional checks

New Contributor

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 IdFull/part timecount
C001Full time5
C001Part time3
C002Full time9
C002Part time4

I want to convert it like this

Abc IdFull TimePart time
C00153
C00294

 

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@sadafzafar A pivot table will do. See picture.

Riny_van_Eekelen_0-1645176116799.png

 

Thanks. It worked