How can I produce a value while querying data from a range in Google Sheets?-CodePudding

Home > Mobile > How can I produce a value while querying data from a range in Google Sheets?

How can I produce a value while querying data from a range in Google Sheets?

Time：10-26

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.

This is how it should look like:

Page link：https//www.codepudding.com/Mobile/588737.html

Prev:Google Sheets - transpose irregular column data in groups into rows

Next:Calculate Days between series of dates in a range

Tags：

google-sheetsgoogle-sheets-formula

Links：
CodePudding