• solved

    select CASE WHEN MIN(t.r) = 1 then t.name1

    ELSE ''

    END as name1,

    t.name2, t.name3, sum(t.sum1), sum(t.sum2)

    from (select *, ROW_NUMBER() over(partition by name1 order by name1) r

    from #tbl1) as t

    group by t.name1, t.name2, t.name3