Solved Merge Records together with the same data in both records (1 Viewer)

[Number11]

So some of the data that comes from another data source has duplicated records for the same customer i need to have these combained into one query record. I have tried to use the "Unique values" but its still puling the same two records for the same customer?

 

[CJ_London]

nothing to go on except speculation which is one or more of the fields contain different data. Please provide the sql to your query and an example of the duplicate

 

[Number11]

nothing to go on except speculation which is one or more of the fields contain different data. Please provide the sql to your query and an example of the duplicate

Ok found the issue by me updating the imported data and setting any blank fields to NULL using an update query "" to NULL has cleared up the issue and its now working