I am trying to create a directory of businesses for a category of social services for a local NPO that I am volunteering at, and I would also like to include a Spanish section due to Spanish-speaking needs in the population. After initially giving up after trying to create a data sheet which would then be transposed onto two worksheets (and just manually doing it through Word), I saw Pivot Tables and have renewed hope.
HOWEVER, the problem that I ran into while creating is that Tabular is the best mode, BUT it automatically groups like what is attached (FYI: Things like Nos being grouped as one big row of No).
I have been looking for a solution to this for over 30 minutes, but I haven't found any solutions that don't create additional issues. Another solution that I am open to is just using formulas within another field to give an asterisk and/or dagger for yes and no questions (as they may fit better on paper). I am also looking at trying to group or sort by zip code or City, but that doesn't seem to work as well.
Is there an easier way to create a spreadsheet for directory that is feasible to print and to distinguish if there is bilingual staff which then can be printed out for clients and staff. Or is a Pivot Table in English then in Spanish my best solution and if so, how do I overcome the problems illustrated above? (Due to limitations and regulations with regard to federal and state laws for this type of NPO, coding and macros are NOT a viable solution.)
Thanks!
