Hello!
I have the following table with different values (rows 2-4) according to the dates (row 1):
| 18.4 | 25.4 | 2.5 | 9.5 |
| La | Lo | Lä | Lö |
| Le | Lu | | Lü |
| Li | | | |
As you can see, all values are unique but let's assume that La & Lä, Lo & Lö and Lu & Lü belong to the same category. My table is small enough to assign these categories manually but of course, if there is a way how to assign a category automatically based on specific characteristics, that would be helpful too.
Now my question is: Is it possible to assign categories to each value, for example assign category 1 to La and Lä, category 2 to Lo and Lö and so on and afterwards filter by these categories?
So for example I want to see all values assigned to category 1? Similar to the following table (considering that La and Lä were assigned category 1):
I hope my question was clear but in case further clarification would be helpful, please let me know :) .
Thanks
