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
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 StateCityStreetFirst NameLast NameCaliforniaLos AngelesBroadwayJohnSmithCaliforniaLos AngelesTemple StreetSamSanchezCaliforniaLos AngelesGrand AvenueDavidShawnCaliforniaLos AngelesHill StreetMaryLeung Read More