P
PL
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.
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.