Table transformation

How would you transform the table on the left to the right in KNIME.

From excel, I can use countif forumlas based on two criteria but I’m unsure how to do so in KNIME