Help with datatable Logic


My input

I need output as

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

Please help

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.

1 Like

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

1 Like

Hi can u provide the excel file

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

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 :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer: