Excel help on consolidating data.

I have a data set (15,000 rows) in excel that looks like the sample below. Is there a way get to some thing that looks like this? Basically I want to count the entries by customer, get the last date,...