Increment row values based on column values in Excel

Help Studio
,
1

Input File –
Expectedoutput.xlsx (10.0 KB)

The image shows a spreadsheet listing various documents related to automotive and material testing, with columns for key codes, language, and document descriptions. (Captioned by AI)
The image shows a spreadsheet listing various documents related to automotive and material testing, with columns for key codes, language, and document descriptions. (Captioned by AI)940×351 180 KB

Please add new column as “NewRowNo”

Always start the first row value with number “3”
If the next row “Key” column’s value is same previous row “Key” column value then increment + 1 in NewRowNo column

If the next row “Key” column’s value is NOT same previous row “Key” column value then increment + 2 in NewRowNo column

Expected output : Attached the expected output file
Expectedoutput.xlsx (10.0 KB)

The image shows a spreadsheet with a list of documents, where specific rows are highlighted in yellow and green, encompassing columns for key, language, new row number, and document titles in both English and German. (Captioned by AI)
The image shows a spreadsheet with a list of documents, where specific rows are highlighted in yellow and green, encompassing columns for key, language, new row number, and document titles in both English and German. (Captioned by AI)940×194 105 KB

2

Hello @Sathish_Kumar_S

Add data column "NewRowNo"
Assign int_Counter = 0
Assign str_PrevKey = ""

For each row in Data Table 
If row("Key").ToString=str_PrevKey
Then assign row("NewRowNo") = int_Counter+1
Else  assign row("NewRowNo") = int_Counter+2
Assign str_PrevKey = row("Key").ToString

Hope it makes sense :slightly_smiling_face:
If not then you are welcome to write me.

Regards
Soren