I need the formula to duplicate specific rows (the rows contain name data) a number of times and add incrementing numbers in the end.
It should look something like this:
I found a way to dublicale the rows, using this formula
=if(Rows(E$2:E2) >$B$10*$B$11;""; index(A$2:A$7; mod(Rows(E$2:E2)-1;$B$13)+1))
Now I need to add numbers in the end. I am wondering if it is possible to do it in one formula, or do I need to create a separate column and concatenate it together.