Forum Discussion
Moving Data to One Row Based on First Mention
With the above 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...
I guess each attribute is a step, correct?
Can you share the excel sample data using google drive or other method and will get back to you with the solution? Thanks!
Yes, there are 5 attributes that represent one of 4 steps - there are 2 different attributes for step 1 - _Step 1 Membership (Attendance) and zOLDStep 1 Follow (Attendance).
I sent you a private link to the example data in google drive.
Thank you for the help!
michaelhodges1 for some reason cannot download the data. can you make sure it is available to download who has access to the link. thanks