I have a file with text divided into cells that I want to group into another cell. Cells are:
A, B, C, and D are what I have. In each coluimn, if the value is Yes, I would like the Result column to display the title of each Yes. So for the first one, as an example, BlueCOMMA GreenCOMMA YellowDOT Is this possible to achieve? If so, how? Thank you.
Edit: 2016 office without 365 subscription doesn't have textjoin. Looking for a LibreOffice / Googledocs answer.