The problem consists of concatenating multiple horizontal ranges containing product1, brand1, price1, product2, brand2, price2 and so on, even when the cells ar
I want to pre-process my data like the Result section of the attached image before flattening and using it. I want to write an array formula in the cells marked
I'm trying do create a master sheet for work, as for nom we work in the middle age, copying some data to up to 4 differents documents and I want that to change
In Google Sheets, is there a way to calculate the width, in pixels, of a piece of text given a font and a font size? Excel has a PixelWidth function, but I didn
I am using the IMPORTHTML function in a Google Sheet cell to import commodities performance table from website : https://www.investing.com/commodities/real-time
I am a newbie on importxml and trying to scrape the property agent information from a website, I did success to get the required field from the page, but:- Ther
I'm trying to get the values for column C in Table 1 from column H by using vlookup. However, seems like the vlookup doesn't work and return a N/A. I had check
I am getting this error on my query. Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC I don't understand whats the problem is
I have found code for a basic 2 column Cartesian join but I have a slightly different situation. There are 3 Variables/Columns: Color, Color ID, & Item. I'd
Sample Table Date Created (A) Tracking ID (B) 5/12/2022 '813vz633-7872' 5/12/2022 '914bz756-7423' 5/12/2022 '875vu340-5687' 5/11/2022 '475dv235-6542' 5/11/2022
Sample Table Date Created (A) Tracking ID (B) 5/12/2022 '813vz633-7872' 5/12/2022 '914bz756-7423' 5/12/2022 '875vu340-5687' 5/11/2022 '475dv235-6542' 5/11/2022
I am using the following Google Sheets formula to translate some fields containing HTML tags: =GOOGLETRANSLATE(A2, "en", "de") However, the translation resul
Here is an example table: A B ------ ---------- 1 | Name | DOB 2 | John | 01/01/2011 3 | Tom | 02/02/2002 I need to return the names of people
My goal is to write a script in Google Sheets that will copy two (or more) values from specific cells on a single row on a worksheet to the bottom of the list o
I have a spreadsheet like this - I can't figure out how to dynamically search for this. I want to find the MAX Score Value + output the related name (no worries
Is that possible to change pivot table totals row location in Google Sheets so that they display directly under the pivot headers? I have browsed the available
Is that possible to change pivot table totals row location in Google Sheets so that they display directly under the pivot headers? I have browsed the available
On sheets, I'm using this formula to sum hours to a specific month from a drop-down menu. =QUERY('Form responses 1'!H2:L, "Select L, Sum(K) WHERE L is not NUL
I have on Google sheets this data (It is the same principle in excel). I want to count the numbers of dose in each strings. I use this formula and it return me
I created two online sheets and tried to collect them in another one sheet by query but there a missing data although it's exists in the original sheets (data s