Easier way for a serie

Copper Contributor
Good afternoon,

I am looking for a way / formula with which I can implement the following series in A column in Excel: 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, etc ...
This is necessary for 250 participants, with 6 rows each.

Is there an easier way than manually pulling each digit up to 6?
Thanks in advance!!
2 Replies

@LvW99 If you're in for a quick and dirty solution, please have a look at the attached file column D. It contains a sequence from 1.1 to 250.6, in groups of 6.

 

@Riny_van_Eekelen Thank you!!!