Given a function that returns an array, is it possible to "spread" the return values as the arguments to another function?
For example, I'd like to pass the result of
SPLIT("example.com,My Site", ",") to the
HYPERLINK(url, [link_label]) function and have it treat
"My Site" as the
=HYPERLINK(SPLIT("example.com,My Site", ","))
but it ignores the second argument.
(This is a simplified example. In reality, the function that's returning the URL and label is a QUERY which I'd like to avoid repeating in the second argument.)