Extracting specific lines from datasheet

Hi

Sorry for the delay. You will find attached a spreadsheet, run the macro named sort_pid and it will pull the info. As for the merging, this part is still on clear his the data always in this format

PID
OBR
PID
OBR
PID
OBR.... I do I know which PID goes with OBR, I need a common field between them so it could be associated with.

Try this for the merging the data

run macro merge_data

see attached document