Try the following select instruction:
SELECT [NAME], MAX(COALESCE(age,1)) as age, max(coalesce(mobile,'')) as mobile,
MAX(COALESCE(address,'')) as address, max(COALESCE(dateoflastupdate,'')) as datsoflastupdate
FROM DATA
GROUP BY [name]
NOTE In the case that the 'mobile' would be a numeric data change max(coalesce(mobile,'')) with max(coalesce(mobile,0))