Here’s another idea which should be better. It’s similar to the split approach but in reverse.
- Make a single Categories table with a column for each level of category, like before, but these are entered manually.
- Add a column with the formula
" > ".join([$Primary, $Secondary, $Tertiary])to combine all the category levels into a single string. - Make a reference column referring to the Categories table and showing the new formula column.
- Use “Add referenced columns” in the settings of the main reference column if you want to extract individual category levels.