...
- Column "F". Title of column can be "Title".
Concatenate Chair and the Chair type.
- Column "G". Header is "Chair, type"
- Code: =CONCATENATE(A1,", ",A1)
Cut-and-pasted people data from "grad" spreadsheet into "master" spreadsheet (columns A-E)
...
...
...