Archie Norman, the British retail executive who led the transformation of the Asda supermarket chain, is to have a key advisory role in Wesfarmers's proposed AUD$22bn (US$17.7bn) acquisition of Australian retail group Coles.