Repetitive cells in a table

Copper Contributor

Is there a way in Table that I can make "California" and "Los Angeles" show only one time and all the other are blank in order for easy reading?

 

Do I need to use macros?

 

Please advise.  Thanks

 

State

City

Street

First Name

Last Name

California

Los Angeles

Broadway

John

Smith

California

Los Angeles

Temple Street

Sam

Sanchez

California

Los Angeles

Grand Avenue

David

Shawn

California

Los Angeles

Hill Street

Mary

Leung

3 Replies

@Sherman995 You could either delete the repetitive entries, or format the font used for them so that it is Hidden and turn off the display of hidden text,

This table is run under some scripts (TeamMate Plus). Is there automatic way that I can learn to check the logic to determine these entry should show or disappear? Thanks

@Sherman995 

Doug has given you the easiest solution.


The developers of TeamMate Plus should be able to give you a report format that does this automatically.

 

Only if you have to generate a new table every day AND TeamMate won't help should you be looking to do anything after the report has been created. You should look for a Word vba developer to help you.