TL;DR: Does anyone know how to show on InDesign file one table field that represents "Category" and under that all other table entries that have that same "category"?
Details: I have to create catalog with InDesign, right now I'm stuck with data merge but I'm open for any other way to do this. Situation is next:
I have spreadsheet with informations formated like this:
And my InDesign file should show like this:
What differs my question and my project is that under categories I have subcategories but I'm thinking if I manage to figure out how to handle categories I could do the same for SUBs.