Here is the use case (for 20K + records so definitely want to automate it):

I have 5 different multi-select columns that are tags which describe the primary field/ record. For example:

Field 1: Oranges, apples, bananas

Field 2: Box, cup, bowl

Field 3: Human, cow, dog

Field 4: Blue, red, yellow

Then, I have different fields where I want to exhaust all possible combinations, for example:
Tag 1: oranges, box, human, blue

Tag 2: oranges, box, human, red

Tag 3: oranges box, human, yellow

Tag 4: oranges, cup, human, blue

And so on and so forth. You can see that this creates very many possible combinations. And in some instances there could be 10 tags selected in one field. And to do this manually across 20K records would not only be incredibly time-consuming and tedious, but there is a lot of room for human error.

Is there a formula/ script/ automation that can help auto-tag "Tag 1, 2, 3,....." fields each with one unique combination of tags from muli-select fields where tags exist?

And, as a new record is created and tagged, or as tags in fields change, create new combinations of Tag fields?

Thank you in advance!