merge duplicate and if value in b column not match copy to

I have this sheet with this data


Barcode price
Z412N-AST1 12
Z412N-AST1 12
Z412G-AST3 10
Z178B-2PCK 19
Z412-AST 11
Z412G-AST3 20
Z412G-AST3 20
Z178N-2PCK 11
Z178B-2PCK 11
Z412N-AST1 15
Z412N-AST1 20

how i can get it like this

colA colB colc colD
Barcode price
Z412N-AST1 12 15 20
Z412G-AST3 10 20
Z178B-2PCK 19 11
Z412-AST 11

Thank's a lot for your answer

but I found duplicate in price column

for example

Barcode price
Z412N-AST1 12
Z412N-AST1 12
Z412N-AST1 15

the result must be

Barcode price
Z412N-AST1 12 15


many thanks

See if this is what you wanted.

Please Login or Register  to view this content.