A man who died in a fatal road traffic collision in Andover has been named as we continue to appeal for witnesses.