I have a report that comes from a large data house and it unfortunately,
repeats the company name and ID number and address on rows for as many rows
as it takes to show all of the records for a company based on the different
locations.

What is a good way to elimate the repeat cluster of cells leaving alone the
different cells showing the different locations

11 | East hwy | Bob | Location 1
11 | East hwy | Bob | Location 2
11 | East hwy | Bob | Location 3