I need to create a unique data from a spreadsheet with the design as below:

1/1/07 2/1/07 3/1/07 ...... (date at row 1)

9am abc xyz (empty)
11am rst abc xyz
2pm xyz rst (empty)

The expected result is:

abc 2
rst 2
xyz 3

which show the unique data from the table with the number it appeards.

Thank you for your help in advance.