Help Grouping/Replacing Rows

Question

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?

Data Request.xlsx

JBLove · Accepted Answer

@mallieteal21 -

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.