Removing Duplicates but merging the rows with missing information

wingtc99

Hi, I have merged two sets of lists together, now I am trying to get a unique list. The problem is that list 1 is does not contain the middle 3 columns, which results in a null.

I have used the unique tool, however it removes rows with full sets of data and leaves the rows with nulls as a unique row, is there a way to merge and auto fill this so that I could get a row such as:

Armada Boat Hire, XYZ, 123, XYZ, XYZ. 

Thanks

Christina_H

The unique tool will always take the first row for each item, so just sort it to make sure the populated rows come first.