removing duplicates and merge all data into one line

[Patriot2879]

HI i really hope you can help me with the below query in VBA code in excel, i have the following issue with duplicates on a spreadsheet and mssing data on duplicate lines but i want this merged all into one line if possible.
-Sheet name = Sheet1
-Data range (column(s), rows) = A - Z
-Data-type (text, numbers, mixed) = mixed but for example column A will be a 13 number combination, column S will be notes added, column T will be customer contact details column V will be customer name, Column W will be address1, column X will be address2 and column Y will be postcode
-Expected result - Column A is the primary column but sometimes this is duplicated and on one line it could have notes, and on the next line notes are missing and the customer phone numner is in, and address1 on another line then address2 on another, but i want all this to be merged into one line and the other duplicate lines deleted. Can you help with this pleaser? i hope you can? your time is greatly apprecaited. Thank you

 

[Patriot2879]

wow this is amazing thank you again so much for all your help