formula or function to return a string of numbers based on a counter

I have a workbook that has a counter button. When data is entered in a particular column, the counter value is recorded. This data is used to fill in a formula for a specified number of "counts" (button clicks). The number of counts varies depending on the data entered and is supplied from a table using the VLOOKUP function.

What I would like to do is record a list of "counts" that the data will be used in a single cell.

For example, say the data "CAT" is entered in the designated column and the counter reads a value of "5" VLOOKUP function returns the specified values for "CAT" found in a separate table, including a duration value of "3" counts. (So far I have this working) Based on this data, I would like to be able to populate a single cell that would have a value of "5, 6, 7".
The idea I have is I would then be able to use COUNTIF or some other function to look for the "count" value in this cell and run the calculations each time the count value is found. (Haven't gotten this far yet).

It's difficult to describe exactly what I'm trying to do so I've attached an example. Thanks!

Sorry, I'll try to explain better...

The data in column C is entered by the user, "CAT", "DOG", etc, so yes this list would continue to grow. I made the attached example as a simple model of what I'm trying to do. The data table in my working project is much larger and contains more variables.

Yes, the numbers starting in B9 come from the counter. Any entry in column C will populate the counter value into column B. If you were to click the "Turn" button until the counter read "20" and enter anything in column C, column B of the same row would be populated with "20".

No, in the real version of this project, the duration value has a range from 1 to 100.