mfarhan
08-08-2016, 10:10 AM
Dear Experts,
This is my first post, so please excuse me if I break any rules. I am glad to be part of the Forum and appreciate any assistance.
I am facing a problem in the last step of my project where i need to give the compiled data.
I have the output so far as below in a single cell, for example in "C1":
Apple; Apple; Apple; Apple; Banana; Banana; Apple
I need it to become in the same cell "C1":
5 Apple; 2 Banana
I've multiple cells in the same column C which needs to become as above.
Example again:
Data in below form...
Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple
Banana; Apple; Grapes
Banana; Apple; Grapes; Banana; Apple; Grapes
Apple
Apple; Apple; Banana; Grapes; Grapes
Required Output as below:
12 Apple
1 Banana; 1 Apple; 1 Grapes
2 Banana; 2 Apple; 2 Grapes
1 Apple
2 Apple; 1 Banana; 2 Grapes
This is my first post, so please excuse me if I break any rules. I am glad to be part of the Forum and appreciate any assistance.
I am facing a problem in the last step of my project where i need to give the compiled data.
I have the output so far as below in a single cell, for example in "C1":
Apple; Apple; Apple; Apple; Banana; Banana; Apple
I need it to become in the same cell "C1":
5 Apple; 2 Banana
I've multiple cells in the same column C which needs to become as above.
Example again:
Data in below form...
Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple
Banana; Apple; Grapes
Banana; Apple; Grapes; Banana; Apple; Grapes
Apple
Apple; Apple; Banana; Grapes; Grapes
Required Output as below:
12 Apple
1 Banana; 1 Apple; 1 Grapes
2 Banana; 2 Apple; 2 Grapes
1 Apple
2 Apple; 1 Banana; 2 Grapes