My issue is that I am building a workbook (see minimum viable example attached) that identifies multiple topics that occur in each section of a book chapter for multiple book chapters. This workbook will require the users to be able to see a growing list of multiple topics (i.e., categorical data) as an index somehow as they're inputting the data.
Each row is a distinct section of a chapter (e.g., 1.1, 1.2, 2.1, 2.2...), and the primary column (or columns) is a list of topics. There will also be columns with information on each chapter section (e.g., title). See my sample below:
And I want to be able to automatically generate a continuously added list like this:
For excel, I was provided with an example formula solution that doesn't have sheets compatibility: