Fill Data Table Columns with Sequential Data

[#1]

Hello,

a newbie question:

Is there an option to use the "Fill" option with the sequential character ordinal data?

Currently the sequence of Character data is only repeated, and is not continued.

For example, I write "User 1", "User 2", "User 3", and want to continue the sequence till the end of the table (100 rows)
if I highlight the data I've entered and choose the "Fill to end of table", i get the repetitions of the first three rows.

Thanks in advance

[#2]

You could create one column with the numbers from 1-100 and then other with only "User". Then use formula to combine those two, remove formula and remove the original columns.

Column with "User" values should be first in the table

Then remove unnecessary columns if needed

Select Remove Formula here

[#3]

I find a little JSL can go a long way for simple tasks such as this.

New Table( "example",
	add rows( 100 ),
	New Column( "sequence", character, set each value( "User " || char( Row() ) ) )
);

[#4]

In addition to jthi and Jim here how the formula can be built interactively as well: