an example:
SELECT case when t.rowno=1 then CompanyName else null end as CompanyName, Product, Price, NrOrdered, Status
FROM
(
SELECT Row_Number() over (partition by CompanyName order by CompanyName ) as rowno
, CompanyName, Product, Price, NrOrdered, Status
FROM YourTable
) as t