'group columns adding a row number

Could someone help how can I add a column with row number based on the question no criteria: question ID starts in 1 and ends in 54.

criteria is: if question no is from 1 to 54, then group 1 and so on

the data is something like

enter image description here

the desired is:

enter image description here

Tks a lot



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source