Forum Discussion

RupertBear's avatar
RupertBear
Regular Visitor
7 years ago
Solved

Repeating Index Colum over Values 1-n

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 

 

Need Help
Tips and Tricks
Tutorial Requests
  • PradipMCT's avatar
    PradipMCT
    7 years ago

    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)

1 Reply

  • PradipMCT's avatar
    PradipMCT
    Resolver II
    7 years ago

    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)