Moving Data into one Row Based on ID and First Mention

[michaelhodges1]

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.

[TABLE="width: 1639"]
<tbody>[TR]
[TD]Individual ID[/TD]
[TD]Last Name[/TD]
[TD]First Record[/TD]
[TD]Postal Code[/TD]
[TD]Attribute Group[/TD]
[TD]Attribute[/TD]
[TD]Start Date[/TD]
[TD]Step 1[/TD]
[TD]Date[/TD]
[TD]Step 2[/TD]
[TD]Date2[/TD]
[TD]Step 3[/TD]
[TD]Date3[/TD]
[TD]Step 4[/TD]
[TD]Date4[/TD]
[/TR]
[TR]
[TD]34376725[/TD]
[TD]Aaron[/TD]
[TD]10/21/2010[/TD]
[TD]35205[/TD]
[TD]Grants Mill Growth Track[/TD]
[TD]_4 Dream Team (Attendance)[/TD]
[TD]09/22/2013[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34376725[/TD]
[TD]Aaron[/TD]
[TD]10/21/2010[/TD]
[TD]35205[/TD]
[TD]Grants Mill Growth Track[/TD]
[TD]_4 Dream Team (Attendance)[/TD]
[TD]10/24/2010[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34376725[/TD]
[TD]Aaron[/TD]
[TD]10/21/2010[/TD]
[TD]35205[/TD]
[TD]Grants Mill Growth Track[/TD]
[TD]_1 Membership (Attendance)[/TD]
[TD]03/06/2011[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34376725[/TD]
[TD]Aaron[/TD]
[TD]10/21/2010[/TD]
[TD]35205[/TD]
[TD]Grants Mill Growth Track[/TD]
[TD]zOLDStep 1 - Follow (Attendance)[/TD]
[TD]08/14/2011[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34376725[/TD]
[TD]Aaron[/TD]
[TD]10/21/2010[/TD]
[TD]35205[/TD]
[TD]Grants Mill Growth Track[/TD]
[TD]_4 Dream Team (Attendance)[/TD]
[TD]08/26/2012[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34376725[/TD]
[TD]Aaron[/TD]
[TD]10/21/2010[/TD]
[TD]35205[/TD]
[TD]Grants Mill Growth Track[/TD]
[TD]_4 Dream Team (Attendance)[/TD]
[TD]07/22/2012[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34376725[/TD]
[TD]Aaron[/TD]
[TD]10/21/2010[/TD]
[TD]35205[/TD]
[TD]Grants Mill Growth Track[/TD]
[TD]_2 Discovery (Attendance)[/TD]
[TD]10/17/2010[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24148658[/TD]
[TD]Aaron[/TD]
[TD]3/16/2009[/TD]
[TD]36109[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]_1 Membership (Attendance)[/TD]
[TD]04/02/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24148658[/TD]
[TD]Aaron[/TD]
[TD]3/16/2009[/TD]
[TD]36109[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]_1 Membership (Attendance)[/TD]
[TD]08/04/2013[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24148658[/TD]
[TD]Aaron[/TD]
[TD]3/16/2009[/TD]
[TD]36109[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]zOLDStep 1 - Follow (Attendance)[/TD]
[TD]10/04/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24148658[/TD]
[TD]Aaron[/TD]
[TD]3/16/2009[/TD]
[TD]36109[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]_2 Discovery (Attendance)[/TD]
[TD]05/16/2010[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24148658[/TD]
[TD]Aaron[/TD]
[TD]3/16/2009[/TD]
[TD]36109[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]_4 Dream Team (Attendance)[/TD]
[TD]08/01/2010[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24148658[/TD]
[TD]Aaron[/TD]
[TD]3/16/2009[/TD]
[TD]36109[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]_1 Membership (Attendance)[/TD]
[TD]05/02/2010[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24148658[/TD]
[TD]Aaron[/TD]
[TD]3/16/2009[/TD]
[TD]36109[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]zOLDStep 1 - Follow (Attendance)[/TD]
[TD]09/12/2010[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24148658[/TD]
[TD]Aaron[/TD]
[TD]3/16/2009[/TD]
[TD]36109[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]_3 Leadership (Attendance)[/TD]
[TD]04/23/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24148658[/TD]
[TD]Aaron[/TD]
[TD]3/16/2009[/TD]
[TD]36109[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]_2 Discovery (Attendance)[/TD]
[TD]06/21/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]81005114[/TD]
[TD]Aaron[/TD]
[TD]6/7/2016[/TD]
[TD]35473[/TD]
[TD]Tuscaloosa Growth Track[/TD]
[TD]zOLDStep 1 - Follow (Attendance)[/TD]
[TD]06/05/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]81005114[/TD]
[TD]Aaron[/TD]
[TD]6/7/2016[/TD]
[TD]35473[/TD]
[TD]Tuscaloosa Growth Track[/TD]
[TD]_1 Membership (Attendance)[/TD]
[TD]07/10/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]81005114[/TD]
[TD]Aaron[/TD]
[TD]6/7/2016[/TD]
[TD]35473[/TD]
[TD]Tuscaloosa Growth Track[/TD]
[TD]_2 Discovery (Attendance)[/TD]
[TD]08/21/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]81005114[/TD]
[TD]Aaron[/TD]
[TD]6/7/2016[/TD]
[TD]35473[/TD]
[TD]Tuscaloosa Growth Track[/TD]
[TD]_4 Dream Team (Attendance)[/TD]
[TD]08/28/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23605006[/TD]
[TD]Aaron[/TD]
[TD]2/23/2009[/TD]
[TD]36064[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]_1 Membership (Attendance)[/TD]
[TD]04/02/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23605006[/TD]
[TD]Aaron[/TD]
[TD]2/23/2009[/TD]
[TD]36064[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]_2 Discovery (Attendance)[/TD]
[TD]05/14/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23605006[/TD]
[TD]Aaron[/TD]
[TD]2/23/2009[/TD]
[TD]36064[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]_3 Leadership (Attendance)[/TD]
[TD]08/20/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23605006[/TD]
[TD]Aaron[/TD]
[TD]2/23/2009[/TD]
[TD]36064[/TD]
[TD]Montgomery Growth Track[/TD]
[TD]_4 Dream Team (Attendance)[/TD]
[TD]08/27/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]84010169[/TD]
[TD]Aaron[/TD]
[TD]1/24/2017[/TD]
[TD]35501[/TD]
[TD]Tuscaloosa Growth Track[/TD]
[TD]_3 Leadership (Attendance)[/TD]
[TD]01/01/2001[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]84010169[/TD]
[TD]Aaron[/TD]
[TD]1/24/2017[/TD]
[TD]35501[/TD]
[TD]Tuscaloosa Growth Track[/TD]
[TD]_2 Discovery (Attendance)[/TD]
[TD]01/01/2001[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]89377362[/TD]
[TD]Aaron[/TD]
[TD]2/19/2018[/TD]
[TD]35904[/TD]
[TD]Gadsden Growth Track[/TD]
[TD]_3 Leadership (Attendance)[/TD]
[TD]11/19/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]89377362[/TD]
[TD]Aaron[/TD]
[TD]2/19/2018[/TD]
[TD]35904[/TD]
[TD]Gadsden Growth Track[/TD]
[TD]_2 Discovery (Attendance)[/TD]
[TD]02/11/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]79987256[/TD]
[TD]Aaron[/TD]
[TD]4/25/2016[/TD]
[TD]35243[/TD]
[TD]Grandview Growth Track[/TD]
[TD]_3 Leadership (Attendance)[/TD]
[TD]01/01/2001[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[pmich]

Experts in this forum may understand what you are saying. But I need some clarification.


1. You say 'per unique identifier'. You also say 'some people'. Are you saying that each individual has to be identified by the Individual ID?
2. You say 'each person'. In the expected result you want only one row for each individual. But, in the 8 empty columns, no column is allotted for entering names or ID. Then how will you know which row in the result refers to which person? Do you want the result to be mentioned in the first row of each individual or in the 1st Step of each person or do you prefer to allot a column for ID?
3. You say 'STEPS'. Do you mean that the numbers mentioned in the attribute column are STEPS?
4. Should the zOLDStep be ignored?


It will be good if you post an example to show how the results will be after running the VB Code, which we are going to come up with.