I have a little table with some source parameters, for example:
Name | n | rate Term1 | 3 | 2.79 Term2 | 4 | 3.00 Term3 | 2 | 2.59
What I want is, based on the above params, create a big table with the number of rows defined by the sum of "n" column. Basically the "n" column should indicate the number of rows for that particular term, and then go to the next one.
Name | Seq Term1 | 1 Term1 | 2 Term1 | 3 Term2 | 1 Term2 | 2 Term2 | 3 Term2 | 4 Term3 | 1 Term3 | 2
The number of rows in the initial "params" table is also arbitrary, but we can assume that term naming is sequential (if that helps with Regex if required)