1. Transform data and generate unique identifier Separate EmployeeCode values into distinct columns D through G. (18 points; 4.5 point per column) Hint: These extractions can be performed using a combination of formulas. Lean on formulas you have already used this semester and do your own research to find others. 1. Transform data and generate unique identifier Separate EmployeeCode values into distinct columns D through G. (18 points; 4.5 point per column) Hint: These extractions can be performed using a combination of formulas. Lean on formulas you have already used this semester and do your own research to find others.