Counting Categories in Each Column When Not All Categories Appear with Tidyverse

Reshaping an Excel Sheet with a Header in Three Rows to Tidy Data Format Using R and Tidyverse Package