Forum Discussion
Helper IIRow index numbers changes
Hi tabuzahra ,
When you create an index in Power Query, it increments on every row. The only thing that I could see would be to hard code 1,2,3 into a column in Excel that is part of your table. That way the values should read 1,3 if you delete row 2 and you retain your original numbering of the remaining rows.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Community ChampionHi tabuzahra ,
When you create an index in Power Query, it increments on every row. The only thing that I could see would be to hard code 1,2,3 into a column in Excel that is part of your table. That way the values should read 1,3 if you delete row 2 and you retain your original numbering of the remaining rows.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel