I am trying to re-arrange my table and do some inter-table mapping
My input looks like this (I used the binocular function)
| Animal | Weight | Diet | Mammal | Color |
| Tiger | 500 | meat | Big Bear | White |
| Polar Bear | 1000 | fish | Antelope | Brown |
| Deer | 150 | grass | Big Cat | Orange |
So, my table is disordered
Is there a mapping I could do (not using fuzzy match) but actual mapping code or something I could write to make it so that I can put some kid of formula like "Tiger" = "Big Cat" and then if a new animal was added, I could just update that code or mapping template. Basically need to make sure the animal column is able to match the corresponding mammal column.
Ideally, I'd want my output to be like this:
| Animal | Weight | Diet | Color |
| Tiger | 500 | meat | Orange |
| Polar Bear | 1000 | fish | White |
| Deer | 150 | grass | Brown |
