Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
I have a big Google Sheet and I need to do something like this:
x A x B x C
A AA BA CA
B AB BB CB
C AC BC CC
What formula would allow me to copy the info from the above and right cells into one cell?
(Sorry for the x’s couldn’t figure out how to get a double space)
=arrayformula(B1:D1&A2:A4)
in B2 gives this:
