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 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.
HELP PLEASE! And thank you!
3 Replies
- parry2k
Super User
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!
- parry2k
michaelhodges1 for some reason cannot download the data. can you make sure it is available to download who has access to the link. thanks
