Help with datatable Logic

[Sweety_Girl]

Hi

My input

I need output as

I need to mark it as group by numbering 1,2 …

Please help

[bcorrea (Bruno Correa)]

I think you can create an integer variable and assign it to 1, then in a for each row, you put an if condition to see if you have an empty cell and increase the variable, setting the b column to that variable value.

[ppr (Peter Preuss)]

@Sweety_Girl
find fixed starter help here:
GroupNumberings.xaml (10.9 KB)

[NIVED_NAMBIAR (NIVED N)]

@Sweety_Girl
Hi can u provide the excel file

And my next query how are u providing count to the blank cell in A column

[Pratik_Wavhal]

Hi @Sweety_Girl

Below is the workflow for the same :-
MainPratik.xaml (10.9 KB)
New Microsoft Excel Worksheet.xlsx (8.7 KB)

Input :-

Output :-

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal