Data Consolidation

I have a spreadsheet with over 3000 names, dates of notification of training, and dates of completed training.  Roughly 2000 of those names are the same people,  I am trying to find out if there is some sort of formula that would help me consolidate all of the data so that one row would show one persons name, and the dates of notification and completion.  Something along the lines of the following:

 

Lastname Firstname Classification Sent Date Sent Date Completion Date Completion Date
Abootorab Fatemeh Med Cons 2/14/2012 12/26/2012
Abraham Maha ER I 4/4/2011 2/14/2012 6/8/2006
Abrams Alan Member 10/24/2012
Abrantes Sharon Enforcement Rep I 2/14/2012
Acevedo Christopher ER I 2/14/2012
Ackerman Edward Pst Con Spec 4/4/2011
Ackley James D SUP INV I/DCA

2/14/2012

3/31/2013

 

 

 

 

 

By: Troy

Leave a Reply

Your email address will not be published. Required fields are marked *