My data table is setup like so:
93000 A Tech1
93000 B Tech1
93000 C Tech2
93000 A Tech2
93000 A Tech1
93000 A Tech1
93000 A Tech1
93100 B Tech1
93100 C Tech1
93100 C Tech1
93100 A Tech1
93200 B Tech2
93200 C Tech2
93200 C Tech2
93200 A Tech2
93200 A Tech2
93200 A Tech2
93200 A Tech2
I amtrying to create a table that counts the unique values like so:
Tech1 Tech2
93000 2 2
93100 3 0
93200 0 3
Thank you in advance if this is poossible.
Bookmarks