517 reputation
111
bio website
location Seattle, WA
age
visits member for 1 year, 11 months
seen Jul 4 at 13:54

Aug
20
comment How to name column headers (column B to X) based on values in column A?
No problem, I'm glad it worked for you. The COLUMNS(A1) is just a cheap way of getting a number that starts at 1 and increases as you copy it to the right. Leave the COLUMN() formula as it was in my original answer and swap the in the "H" like you've selected to give you something like ="obs"&INDIRECT("H"&COLUMN(A1)+1)
Aug
20
awarded  Teacher
Aug
20
answered How do I mount a ssh folder in linux from a script?
Aug
20
answered gnu screen - get list of window titles
Aug
20
answered How to name column headers (column B to X) based on values in column A?