Can I change Google Sheet column headers

Thanks John, what does that arrayformula() look like, do you just put the first cell with data in the original tab in the brackets and drag over and down?  Thanks

@bryan92675 - here is an example that goes in “row two” of the target spreadsheet: 

=arrayformula('Multiple Intelligence - How are you smart? - ww orig'!BF2:BF)

the name of the tab is pulled in by starting the formula in the cell and then doing the old click on the other tab and then the cell  you want routine. The one thing you need to add is the entire range that this should be looking into ie in the example above it says bf2:bf which means start at cell bf2 and go down the entire range of cells 

sometimes you will need to add a little more to the arrayformula if you are looking at doing calculations etc based on the column.. here’s another little bit

=arrayformula(if(isblank(A2:A), " ", (B2:B/35)))

note that this one checks to see of there is data in column A of the row being evaluated.. if there is not data leave the cell blank (“ “) otherwise put in the results of the calculation

hope that helps

thanks so much @john.desborough ! you are a wizard!  appreciate your help

@bryan92675 - happy to help… if it works for you, pay it forward by helping someone out in here or buying a coffee for a stranger.. lol

cheers

des