This worked perfectly !

Could you please comment on the following to let me know what it means. That will be a great help in understanding the code for me to experiment.

Code:

for i in $(tail -n+2 file.tmp | tr '\t' '\n' | sort -un)
do
  tail -n+2 file.tmp | cut -f1 | grep -w $i 1>/dev/null 2>&1
  let a=1-$?

To go one step ahead, in the output, how can I add another column lets say "e" after "d" which contains the sum of values in a, b, c and d. In other words, because 0 was present in all 4 initial columns in file.tmp, it got a value of 1(for existence) in all 4 output columns. How can I generate a column "e" which contains the sum of all these new entries, so inthe case of 0 I should get 4, and so on for the rest of the list.
I know I can do this in excel but I want to learn the command line for this.
Thanks a lot for the useful input.