Calc: Need help with macro, formula or other method to automate changes

I have a row of data that I would like to duplicate and make into many rows of data, with certain specific changes to certain cells.

For example, I have something like this:
101 101 xyzabc101 other data…

I would like to increment each of those 101’s so I get additional sequential new rows as follows:
102 102 xyzabc102 other data…
103 103 xyzabc103 other data…
Perhaps 30 new rows so that my final row is:
130 130 xyzabc130 other data…

How can I accomplish this goal without manually making 90 changes?
The first two columns I have a decent idea of how I can do it. The combination of text and number in the third column is the real problem. I was thinking maybe somehow segregate the text and number somehow and then combine with a new final result… but I have no idea how to do that. I believe Excel had some sort of text format function but I can’t remember what it’s called, nor do I know if Calc has something similar. Finally I’m not sure it would work for what I want. So really stuck here. I suppose in javascript something like for (i=101; i<131; i++) {colA=i; colB=i; colC=“xyzabc”+i;} might do the trick, but I don’t know how to get from here to there. Never programmed with calc before.

Thank you

Maybe so?


Відмінне рішення - Libre Calc has many surprising features. Thanks for showing us this one.

That’s brilliant! Thank you!