Filter the data based on specific column

Hello,

I am trying to fill this table.

image

Input:

in excel I have two columns,

image

Output

image

can anyone please help me?

Thank you

@Dev2

For totals and percentage use formulae already in the template so that it auto calculates

You only need to populate the number now

For that read the input data and usw for each row in datatable activity and then use find or replace to search for A B C depending on the currentrow value in the loop…once you get the row…column you need is directly from the value

Column is already known for pass fail and so use them as needed and then use write cell with the values you get

Cheers

can you give me an example of how I can fill the number?

@Yoichi @ppr @ can you please help me?