Repeating Data

[Guest]

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

 

[Ian]

Use conditional formatting to hide the repeated data.

Assuming your data starts in A1 then in A2 use Cell Value Is equal to =A1 as
the condition and set the format so text and backgraound are the same
colour.

Copy A2 and Edit>Paste Special>Formats to the other cells (A2:C3 in your
example) and the conditional formatting reference will change accordingly.