; WITH cteTableName AS

(

SELECTROW_NUMBER() OVER( PARTITION BY Man_name ORDER BY Model ) RowNum, *

FROMTableName

)

SELECTCASE WHEN RowNum > 1 THEN '' ELSE Man_name END Man_name, Model

FROMcteTableName

This should do it for you..