The UK retail executive who led the transformation of the Asda grocery chain will have a key advisory role in the proposed Wesfarmers acquisition of Coles.