*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
- 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))
- CutCopy-and-paste results into "C" as "Values" only., then delete column H
- Can't use cut, since Paste won't allow "Values" paste off a cut
Cut-and-pasted people data from "grad" spreadsheet into "master" spreadsheet (C-G => A-E)
...