Repeating Index Colum over Values 1-n

[RupertBear]

Hi,

I am struggling to implement a new index column that starts from one, counts up to 44 and then repeats this until the end of my data ( the number of rows varies depending on the source).

i.e:

1

2

3

....

44

1

2

3...

Many thanks 

[PradipMCT · Accepted solution]

Hi 

You can create the index column first. 

Power Query --> Add Column --> Index column

Now create a modulo column which you'll find under 

Power Query --> Add column --> Standard --> Modulo 

Enter the number 44 as mentioned by you. 

You are sorted.

If this is the solution then please mark it as a solution while responding. 

Thanks.

Pradip Pardeshi (Microsoft Certified Trainer)