michaelhodges1
New Member
- Joined
- Feb 26, 2018
- Messages
- 2
With the below spreadsheet, I am attempting to have one row per unique identifier. You can see in the 8 empty columns to the right, I need to show if and when each person first attended each of the 4 steps as shown in the Attribute column. However, since some people may have attended one of the steps multiple times, I need to show when they first attended each step.
<tbody>
</tbody>
Individual ID | Last Name | First Record | Postal Code | Attribute Group | Attribute | Start Date | Step 1 | Date | Step 2 | Date2 | Step 3 | Date3 | Step 4 | Date4 |
34376725 | Aaron | 10/21/2010 | 35205 | Grants Mill Growth Track | _4 Dream Team (Attendance) | 09/22/2013 | ||||||||
34376725 | Aaron | 10/21/2010 | 35205 | Grants Mill Growth Track | _4 Dream Team (Attendance) | 10/24/2010 | ||||||||
34376725 | Aaron | 10/21/2010 | 35205 | Grants Mill Growth Track | _1 Membership (Attendance) | 03/06/2011 | ||||||||
34376725 | Aaron | 10/21/2010 | 35205 | Grants Mill Growth Track | zOLDStep 1 - Follow (Attendance) | 08/14/2011 | ||||||||
34376725 | Aaron | 10/21/2010 | 35205 | Grants Mill Growth Track | _4 Dream Team (Attendance) | 08/26/2012 | ||||||||
34376725 | Aaron | 10/21/2010 | 35205 | Grants Mill Growth Track | _4 Dream Team (Attendance) | 07/22/2012 | ||||||||
34376725 | Aaron | 10/21/2010 | 35205 | Grants Mill Growth Track | _2 Discovery (Attendance) | 10/17/2010 | ||||||||
24148658 | Aaron | 3/16/2009 | 36109 | Montgomery Growth Track | _1 Membership (Attendance) | 04/02/2017 | ||||||||
24148658 | Aaron | 3/16/2009 | 36109 | Montgomery Growth Track | _1 Membership (Attendance) | 08/04/2013 | ||||||||
24148658 | Aaron | 3/16/2009 | 36109 | Montgomery Growth Track | zOLDStep 1 - Follow (Attendance) | 10/04/2015 | ||||||||
24148658 | Aaron | 3/16/2009 | 36109 | Montgomery Growth Track | _2 Discovery (Attendance) | 05/16/2010 | ||||||||
24148658 | Aaron | 3/16/2009 | 36109 | Montgomery Growth Track | _4 Dream Team (Attendance) | 08/01/2010 | ||||||||
24148658 | Aaron | 3/16/2009 | 36109 | Montgomery Growth Track | _1 Membership (Attendance) | 05/02/2010 | ||||||||
24148658 | Aaron | 3/16/2009 | 36109 | Montgomery Growth Track | zOLDStep 1 - Follow (Attendance) | 09/12/2010 | ||||||||
24148658 | Aaron | 3/16/2009 | 36109 | Montgomery Growth Track | _3 Leadership (Attendance) | 04/23/2017 | ||||||||
24148658 | Aaron | 3/16/2009 | 36109 | Montgomery Growth Track | _2 Discovery (Attendance) | 06/21/2015 | ||||||||
81005114 | Aaron | 6/7/2016 | 35473 | Tuscaloosa Growth Track | zOLDStep 1 - Follow (Attendance) | 06/05/2016 | ||||||||
81005114 | Aaron | 6/7/2016 | 35473 | Tuscaloosa Growth Track | _1 Membership (Attendance) | 07/10/2016 | ||||||||
81005114 | Aaron | 6/7/2016 | 35473 | Tuscaloosa Growth Track | _2 Discovery (Attendance) | 08/21/2016 | ||||||||
81005114 | Aaron | 6/7/2016 | 35473 | Tuscaloosa Growth Track | _4 Dream Team (Attendance) | 08/28/2016 | ||||||||
23605006 | Aaron | 2/23/2009 | 36064 | Montgomery Growth Track | _1 Membership (Attendance) | 04/02/2017 | ||||||||
23605006 | Aaron | 2/23/2009 | 36064 | Montgomery Growth Track | _2 Discovery (Attendance) | 05/14/2017 | ||||||||
23605006 | Aaron | 2/23/2009 | 36064 | Montgomery Growth Track | _3 Leadership (Attendance) | 08/20/2017 | ||||||||
23605006 | Aaron | 2/23/2009 | 36064 | Montgomery Growth Track | _4 Dream Team (Attendance) | 08/27/2017 | ||||||||
84010169 | Aaron | 1/24/2017 | 35501 | Tuscaloosa Growth Track | _3 Leadership (Attendance) | 01/01/2001 | ||||||||
84010169 | Aaron | 1/24/2017 | 35501 | Tuscaloosa Growth Track | _2 Discovery (Attendance) | 01/01/2001 | ||||||||
89377362 | Aaron | 2/19/2018 | 35904 | Gadsden Growth Track | _3 Leadership (Attendance) | 11/19/2017 | ||||||||
89377362 | Aaron | 2/19/2018 | 35904 | Gadsden Growth Track | _2 Discovery (Attendance) | 02/11/2018 | ||||||||
79987256 | Aaron | 4/25/2016 | 35243 | Grandview Growth Track | _3 Leadership (Attendance) | 01/01/2001 |
<tbody>
</tbody>