Search code examples
splitgoogle-sheetsarray-formulas

Googlesheets: How to name multiple columns with arrayformula when using split

I am using ARRAYFORMULA together with SPLIT as you can see in this Google sheet. The Formula for B column is this:

=arrayformula( if( row(B:B)=1, "Protokoll",IF(ISBLANK(A:A),"",SPLIT(A:A, "/")  )))

Unfortunately, All columns (B–G) are being named the same as defined in the ARRAYFORMULA in column B. However I want them to be named like this:

B=Protocol, C=Root, D=Level 1, E=Level 2

and so on.

Any ideas how to get this working?

Solution

  • Type the heading manually in B1:G1
    Use the ARRAYFORMULA in B2