As an example, contemplate that one had a Pivot Table to attempt to record various words and their meanings across multiple languages. So, for example, the word for yes in various languages. "Oui" in French and "Si" in both Italian and Spanish. One wanted to assess which languages had the same word for "Yes" as well as the same word for various other concepts, that the language shared the same word with another language. So, for example, "toro" means bull in both Spanish and Italian, while Ventura means "good fortune" in both Spanish and Italian. How could I set up a Pivot Table that would return all other languages where "Si" means yes, toro means bull and Ventura means "good fortune"?
Bookmarks