I have a Google Sheet with a lot of columns, each of them containing words from a category. I would love to create a formula that can retrieve random words and put them together. For example:
Colum 1 [cute, fav, dear, great] Column 2 [love, friends, family, peers]
With the formula you get a random mix e.g. "cutelove", "favpeers", "greatlove", etc.
My knowledge is pretty basic, so I would love to know if this is even doable or at least where could I start. Really appreciate the help.