I am currently using Google Sheets to organize and update the keywords I use in Adobe Lightroom (Photo organizing software) I'm trying to organize my keywords into hierarchies to make it easier to navigate, think Animals>Mammals>Dogs>Mixed-Breed Dogs. This is how it's laid out in Google sheets:
In case it isn't clear, the keywords that will appear under each keyword header are listed one row down and one column over. So going back to my first example, Animals would be in cell A1, Mammals would be B2, Dogs would be C3, and Mixed-Breed Dogs would be D4. Keyword synonyms are contained in curly brackets and likewise listed one row down and one column over. So with Mixed-Breed Dogs we would have listed in column E, starting from E5, terms like "mutt", "mongrel", "uncertain breed" listed and contained in brackets.
I now have two questions:
Is there a way to "parent" cells, so that when the parent cells are sorted the child cells maintain their relative position? For instance, if I want to reverse alphabetize the keywords in Column B of my picture, is there a way to link the words in Column C to move with them and retain their row/column order?
Is there a way to automatically add curly brackets around a cell value? I don't want to have to manually click on each cell and type in brackets around each individual synonym.