Basically I’m very new to UiPath & I doesn’t possess with any VB knowledge.
Right now I’m stuck here as I’m trying to get a unique row count for a single column.
As below, I got a range of data, but i would only want to get the unique count of each of the category.
and make it to be able to write down on a same sheet to something like this:
I tried to use the pivot table activities but i unable to get the same result as i done pivoting inside Excel.
I tried to use the IF activities, but i unable to simulate it to write on the same sheet, i only manage to do it to present as a messagebox.
May i know what is the best & simplify way for me to get the result that i seek for?