Hello
I have a data sheet that has sorted values in ColA:D. For each line on the
list I would like to compare the values in ColB and ColD to the values in the
next line. If B1=B2 and D1<D@ then I would like to copy A2:D2 to E1:H1 and
then delete Row2.
Example

Dog 123456 Blue 500
Dog 123456 Red 400
Dog 234123 Blue 500
Dog 234123 Blue 500

Would become:
Dog 123456 Blue 500 Dog 123456 Red 400
Dog 234123 Blue 500
Dog 234123 Blue 500

Thanks for all replies
Louise