Forum Discussion
Sherman995
Jun 26, 2024Copper Contributor
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 |
- Sherman995Copper ContributorThis 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_KenyonBronze Contributor
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.
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,