• Something like this may work:

    with base as (
    select
      rn = row_number() over (partition by Account order by Sharetype asc)
      , Account
      , ShareType
    from
      Account
    )
    select
      Account
      , ShareType1 = case ShareType when 1 then 'Yes' else 'No' end
    from
      base
    where
      rn = 1;