...

• Insert column "C".
• Header is "Chair, type"
• Add code to first blank column, at end ("H"):
  • =IF(ISBLANK(A2),"No Chair specified",CONCATENATE(A2,", ",B2))
• Cut-and-paste results into "C" as "Values" only.

Cut-and-pasted people data from "grad" spreadsheet into "master" spreadsheet (

...

C-G => A-E)

• Copy out the 5 key columns (C=>G) of data, not including header row.
• Paste below the set of faculty data so that data is not over-written.

Clean up NetID's from Grad data in final sheet

• Filter-select just "Grad" in Title column ("E").
• Add code to column "I" for all Grads:
  • =SUBSTITUTE(DCell_Number,"@cornell.edu","")
• Paste as "Values" into NetID column, "E".

Cut-and-pasted people data from "grad" spreadsheet into "master" spreadsheet (columns A-F => A-F)

====================

Cut-and-paste email addresses from NetID column (D) to Email address column (H).

...