*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Concatenate Chair and the Chair type.
- Insert column "C".
- Header is "Chair, type"
- CodeAdd 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 (columns A-E)
...