So with Google Apps Script, I have a spreadsheet as following:
A B C...
apple banana orange...
banana orange grape...
banana apple orange...
... ... ...
...and I want to make it like this:
apple 2
banana 3
grape 1
orange 3
What would be the easiest way to make this possible?
I have tried to use query function on Google Apps Spreadsheet, but since there are multiple columns it is difficult to sort and count. I have also tried to use join and countif function but it tend to get redundant since there are too many columns.
Need help!
this should do the work: