I am trying to create a specific table based on data downloaded from a certain tool. The best way to describe my problem is to check the table with example data and result that I would like to get (link to the Gsheet and screenshot attached below).

Part of the data like "type of activity" sometimes can be done a few times, but in the "result" table they need to be summed up.

CodePudding user response：

Make a pivot table

check data : you have typed clinet instead of client