I have found a cleaner method for adding in the commas and quotations required for the SWITCH formula: =char(34)&join(“””, “””,ARRAYFORMULA(QUERY(A1:A,”SELECT A WHERE A IS NOT NULL”)&”””,”””&QUERY(B1:B,”SELECT B WHERE B IS NOT NULL”)))&char(34)
The post đź’¬ Adding Commas and Quotations for a SWITCH Formula first appeared on Read Write Collect.