Hi
I am not able to generate summary of below data:
As per below format:
Basically i want to know count of fruits held by groups.
I am not able to generate summary of below data:
Group | Fruits |
A | Apple |
B | Apple,Orange |
B | Orange |
B | Lemon |
B | Apple,Lemon |
C | Lemon,Orange |
C | Lemon,Orange,Apple |
C | Apple,Orange |
A | Lemon,Orange |
B | Apple,Lemon |
C | Lemon,Orange,Apple |
B | Apple,Lemon |
C | Lemon,Orange |
D | Lemon |
As per below format:
Summary | Apple | Orange | Lemon |
A | |||
B | |||
C |
Basically i want to know count of fruits held by groups.