![how to merge cells in a table in google docs how to merge cells in a table in google docs](https://i.ytimg.com/vi/di4fmK_K3vc/maxresdefault.jpg)
![how to merge cells in a table in google docs how to merge cells in a table in google docs](https://i.ytimg.com/vi/mfuJV8-X3-4/hqdefault.jpg)
Instead of referencing the original data set we modify the data set to substitute spaces for our oblique tilde ~ character. What has happened with our first QUERY parameter? To merge cells, drag your cursor through the cells you want to combine, right-click, and. To this: QUERY(ARRAYFORMULA(SUBSTITUTE(A1:B3," ","~")),ROWS(A:A)) At this time it's not possible to split cells in a table in Docs unless the cells were previously merged. One such way I achieved this was by changing our original formula: QUERY(A1:B3,ROWS(A:A)) Therefore, what we want to be able to do is to change our imported data set in the QUERY function so that we are operating on data that doesn’t contain any spaces – we want to be able to reserve these spaces for the explicit purpose of being able to split our data back into cells again. For example, my current data set with names isn’t likely to have a tilde character ~. What we’re going to do is to modify our original data by substituting spaces for an oblique character that isn’t used in our data. Therefore, we’re going to need to improvise on the spaces in our current data set. The problem with this strategy is data containing spaces When we perform this change to our formula we see no change to our data, however, the returned values have now defined that first row as a header area. Then we would simply change this third parameter in the QUERY function to 1 – representing the first row. Step2: Press Alt + O M to open the Merge option menu. It’s the third parameter of the QUERY function that will help us in being able to concatenate the data within each column.Īt the moment, from above, we have set the third parameter to 0 which means our data set does not return any headers.īut what if I want to define the first row as being the header? The Merge Cells Keyboard Shortcut In Google Sheets Step1: Select the cells you want to merge. The number of headers in your data set.The QUERY function is a powerful formula in Google Sheets helps to treat data contained in tabular format like a database table which we can perform basic SQL queries on. With both data sets, we have highlighted in grey the returned values from the QUERY function. first name and last name) using QUERY function with no header