QUERY Function

### How to Insert Blank Column Using QUERY in Google Sheets

Often we need to insert one or more blank columns between columns in order to input data that we forgot to insert previously. So it is necessary to ...

### How to Use QUERY with SPLIT Function in Google Sheets

We often need to split a large text string and rearrange them within different columns. Like, if a company has a dataset that contains information on ...

### How to Find 200-Day Moving Average in Google Sheets (2 Ways)

The Simple Moving Average (SMA) calculates the stock's average price over a specific period of time by continuously summing up an agency's stock ...

### How to Find 7-Day Moving Average in Google Sheets

The Simple Moving Average (SMA) constantly adds up an agency's closing price and divides the sum by the number of periods to get the average price of ...

### How to Filter Unique Values in Google Sheets (5 Simple Ways)

Suppose you are working on a dataset where you must remove duplicates and count all the unique values. If your dataset is large then finding every ...

### How to Concatenate Values for IF Condition in Google Sheets

In Google Sheets, you can combine cells by using some functions. CONCATENATE, JOIN and TEXTJOIN are the most popular among them. To apply some ...

### How to Concatenate Two Columns in Google Sheets

In business and finance, combining data from multiple columns can be crucial for analysis and decision-making. One way to do this is through the ...

### Google Sheets QUERY Function to Concatenate Two Columns

When trying to organize a group of data on a single page, Google Sheets' ability to combine columns may be quite useful. It can speed up production, ...

### How to Insert Moving Average Trendline in Google Sheets

In order to see the current trend of any business parameter, moving average trendlines are crucial. It identifies the current trend direction and ...

### How to Find 50 Day Moving Average in Google Sheets

The 50 day moving average is a useful tool for identifying trends in data. It is calculated by taking the average of a security's price over the past ...

### How to Find Largest Value in Column in Google Sheets (7 Ways)

We frequently need to find the largest value in a column in Google Sheets. The largest value in a data range can be used in numerous instances. ...

### How to Apply QUERY for Unique Rows in Google Sheets (4 Ways)

We often use the QUERY function in Google Sheets for database-like searching in a dataset and filtering data according to a required format. We may ...

### How to Use Data Validation and Filter in Google Sheets (4 Ways)

Just one thing to say, to cope with the modern world properly, we have to be fast. Spreadsheets may contain a large amount of data and we don’t have ...

### How to Execute Case Sensitive COUNTIF in Google Sheets

We often use the COUNTIF function for counting the number of cells based on a specific criterion. However, when we use text criteria in the COUNTIF ...

### How to Concatenate in Google Sheets (6 Suitable Ways)

Sometimes it is necessary to join or concatenate information from different cells, columns, or rows. To perform this, copy-paste is handy until you ...