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;