Menù for category

I have 1800 data entries, each has a category and a subcategory (both are text fields of the data type) I would like to create a navigable menu in which the user first chooses the category and then the subcategory and then all the data entries that have those two text field.
The important thing is that when choosing a category, only the sub-categories of that category should remain to be chosen.

The problem is that I should assign to each data entry the category which is a data type, but they are 1800 and they are on an excel sheet with a column of text that identifies the categories

This topic was automatically closed after 70 days. New replies are no longer allowed.