One of the things that Google Sheets has is hundreds of built-in functions we can use to make the job easier. There are cases where we can download some programs that keep on adding more and more functions to make everything easier than how it was before. The last ones are called add-ons, and in this case Unlimited Sheet is one of those.
Right now we will be exploring two of the most basic functions of this add-on, and we’re going to tell you how to use them correctly. You are going to learn how to merge cells and columns in Google Sheets by using Unlimited Sheets, the best add-on you could choose. Google brought us Google Sheets, so we are going to tell you how to use it properly.
What are rows, columns and cells?
The first thing that gets your attention when you open a new spreadsheet are a bunch of rectangle-shaped empty spaces. In the superior part of the grid you’ll see a row with letters, and on the left side there’s a vertical column with numbers.
The main part of the spreadsheet consists of cells that are rectangles formed by the intersection of a row and a column, and each one can carry a single piece of data. Columns are a range of cells that are disposed of in a vertical way and are labeled by the letters on top of the sheet. Meanwhile, rows are the range of cells disposed of in a horizontal way and are labeled with numbers that are on the left side of the sheet.
Executing the function combineAll
One of the main functions you will find in unlimited sheets is the one called combineAll. What this allows you to do is to combine rows and columns in just one column. It’s a really easy thing to do, you just have to follow the next steps:
- After opening a sheet, you will select the cell that’s going to be the first one of the columns that’s going to be filled with the data you’ll combine.
- Before you type the command, you need to add an equal (=) first, if not then it will not execute.
- Write the command, which in this case is combineAll, and type both parentheses on which you will add the interval of columns and rows.
- To add an interval you will write the position of the first and last cell that has the data you want to merge separated by a colon.
For example, if you want to merge cells from A1 to D14 then the command should be something like this: =combineAll(A1:D14).
- Finally, you just have to press enter on your keyboard and it’ll be done.
Executing the function groupByCell
This other function allows you to group the data in an interval of cells in just one. That means that you could take a lot of data confined in different cells in the sheet and then have it in just one cell. In order to do that you need to follow the next steps:
- You will choose the cell on which you want to group the other cells.
- Star typing with the equal symbol (=) before the command.
- Now, you can type the command, in this case, groupByCell, again, using both parentheses at the end.
- Inside the parentheses you will type the cells interval, starting with the first cell and ending with the last, both separated by a colon. for example, to group all cells from A1 to C4 the command should look like this: =groupByCells(A1:C4).
- To execute it, you have to press enter on your keyboard.