Forum Discussion

Sherman995's avatar
Sherman995
Copper Contributor
Jun 26, 2024

Repetitive cells in a table

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

  • Sherman995's avatar
    Sherman995
    Copper Contributor
    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
    • Charles_Kenyon's avatar
      Charles_Kenyon
      Bronze Contributor

      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.

       

Resources