How can I have the first column automatically populated with specific values on each query of the formula?
This is the formula I had started with: ={"COGS",query(Sheet30!A2:D,"select * ")}
, thinking that COGS would be in the rows below, but if I have more than one row in the range POs!J2:V
, it already throws an error.