Excel: Condensing and Counting

On the left is a table documenting individual plants of a single species (B) in different plots.  There is also a Type designation for each plot.  I would like to create a new table which lists each ...