How are you doing your pivot transformation?

you could just select the following from your results.

select

customer_id,

max(new_address) as new_address,

max(new_city) as new_city

from [yourtable]

group by

customer_id