I have two columns, one should be retained as Column and the values in column become row with their counts

Question

Input table and required output

Input Table

Name Fruit

abc Apple abc Ball abc Apple def Apple def Cat ghi Cat ghi Apple ghi Ball

Output as

    Apple   Ball    Cat

abc 2 1 0 def 1 0 1 ghi 1 1 0

I am trying for quite some time to have my view arranged in the table, but could not get the right code to do so. Please help me on this.