Hoping someone can help me with a grouping/formula issue I'm having with the attached data set. I want to group the rows by employee ID so there's only 1 row per employee, and essentially replace any N with a Y if an employee has an MBA, Bach, and/or Associates identified in any of the rows.
I originally used a summarize tool and tried grouping by employee ID but that created additional rows since the value is different in each row.
Any suggestions?
Solved! Go to Solution.
You can use a Summarize Tool to group by employee ID, and then use the Concat aggregate function o the field whether the Education level values are stored to generate a list of the Education Level values in a single fie. From there you could use a formula tool to assign the "Y" or "N" based on that education level attained.
Thank you so much!