In Google Sheets, I'm able to use curly braces to enter a series of values that can either be just text or formulas, and Sheets will calculate the formulas. For example, if I were to do ={"names";textjoin(",",,E1:F1)} what would happen is, Names would appear in the cell and one the next row, the textjoin would calculate and produce a result.
The purpose is to make sure the formula is always there even when I delete rows in the dataset so that I don't have to keep writing in the formula.
I can't seem to do this in Excel, I get an error message "there's a problem with this formula".
Is there a way to do this in Excel? I use Google Sheets for personal things, but I have to use Excel at work.
MS Excel have VSTACK() function. Try-
=VSTACK("Names",TEXTJOIN(",",1,E1:F1))