Forum Discussion
Helper IIIHow to make a 1-20 column
Ah, got it now 😄. If you just need a fixed 1-20 column regardless of points or position, the simplest option is to create an Index Column in Power Query.
Transform Data → Add Column → Index Column → From 1
That will give you a permanent 1-20 numbering column that stays the same, while the team names and stats can change each gameweek.
Helper IIIThat didnt work Shar. I would point out that because the points will change every week so dont worry about the teams position etc. I just want a column before GW which shows 1 right trrough to 20 down that column.
Continued ContributorAh, got it now 😄. If you just need a fixed 1-20 column regardless of points or position, the simplest option is to create an Index Column in Power Query.
Transform Data → Add Column → Index Column → From 1
That will give you a permanent 1-20 numbering column that stays the same, while the team names and stats can change each gameweek.