Match-Target — Reverse-Engineer the Roster Cleaner

You're an HR analyst handed two columns: a messy roster in column A (mixed case, inconsistent whitespace) and a department code in column B (E, M, S, F, O). Column D (Target) shows the expected clean output — the format your downstream HRIS requires.

Inspect column D to derive the rule, then reproduce it in column C:

The shape of the target string: <Proper-Cased Trimmed Name> (<Department>). For example, the messy input " alex CHEN " paired with code E becomes the target "Alex Chen (Engineering)".

Your task:

1. In column C (Your Output), write a single formula that combines TRIM, PROPER, and an IFS/SWITCH (or VLOOKUP) for the department-code expansion, with the right concatenation.
2. The formula must drag-fill from C2 → C13.

The grader checks column C; column D is your sanity-check.

Graded cells: C3 (Bree Lin / M → "Bree Lin (Marketing)"), C7 (Fatima Ali / F → "Fatima Ali (Finance)"), C10 (Ivy Wood / O → "Ivy Wood (Operations)").