About 1,236,756 results (3,270 milliseconds)
How can I merge two cells in Sheets and keep contents of both cells ...
https://support.google.com/docs/thread/52208798/how-can-i-merge-two-cells-in-sheets-and-keep-contents-of-both-cells-with-a-comma-in-between?hl=en Jun 8, 2020 ... It lists names in two separate columns (last and first). I would like to merge these cells into one cell, and add a comma between them (ex: Doe, ...
Is it possible to combine (merge) two columns in a google sheet ...
https://support.google.com/docs/thread/33449662/is-it-possible-to-combine-merge-two-columns-in-a-google-sheet?hl=en Mar 13, 2020 ... 2) When I try going to FORMAT the "merge cells" command is greyed out. 3) I have tried CONCATENODE, but couldn't get that to work. All I need is ...
Add and edit tables - Computer - Google Docs Editors Help
https://support.google.com/docs/answer/1696711?hl=en&co=GENIE.Platform%3DDesktop You can move rows and columns or merge cells together. In Google Docs, if you have large tables that cross multiple pages, you can also pin header rows at ...
How to combine two cells with text and a date? - Google Docs ...
https://support.google.com/docs/thread/78157004/how-to-combine-two-cells-with-text-and-a-date?hl=en Oct 20, 2020 ... I am trying to combine two cells, one with “As at” and the other cell is a date “21-Oct-2020” My formula is =B1&" "&B2 , however, the result comes up ...
How to combine two cells with an ARRAYFORMULA or with a ...
https://support.google.com/docs/thread/172052278/how-to-combine-two-cells-with-an-arrayformula-or-with-a-query?hl=en Jul 21, 2022 ... How to combine two cells with an ARRAYFORMULA or with a QUERY? · I have a number of columns with data on worksheet "leaf3". · In B7 (and further ...
Freeze, group, hide, or merge rows & columns - Computer - Google ...
https://support.google.com/docs/answer/9060449?hl=en&co=GENIE.Platform%3DDesktop On your computer, open a spreadsheet in Google Sheets. · Select the rows, columns, or cells to merge. · At the top, click Format and then Merge cells, then select ...
Best way to combine multiple cells (some blank) - Google Docs ...
https://support.google.com/docs/thread/177547432/best-way-to-combine-multiple-cells-some-blank?hl=en Sep 1, 2022 ... I've got a scenario where I'me trying to join multiple columns which I can do with "=ArrayFormula(concatenate(A2:I2&" > , "))".
Combine phrases in multiple cells into one cell, removing duplicate ...
https://support.google.com/docs/thread/6047360/combine-phrases-in-multiple-cells-into-one-cell-removing-duplicate-phrases?hl=en May 13, 2019 ... I am trying to consolidate a list of fish that spans multiple cells into one cell. The final cell should include all of the names of the fish, but also remove ...
Query is Combining Rows When it shouldn't - Google Docs Editors ...
https://support.google.com/docs/thread/12144143/query-is-combining-rows-when-it-shouldn-t?hl=en Aug 16, 2019 ... This filter function returns all the same columns as the original sheet. In each row of data, there are two schools, that game's home team and ...
I want to add a title to a range of cells. - Google Docs Editors ...
https://support.google.com/docs/thread/167460677/i-want-to-add-a-title-to-a-range-of-cells?hl=en Jun 15, 2022 ... ... merging three cells together. To expand the merge to a fourth cell ... The merge icon is the one with two arrows pointing inwards towards each ...
How to importrange two unrelated cells, add the data together and ...
https://support.google.com/docs/thread/11639756/how-to-importrange-two-unrelated-cells-add-the-data-together-and-show-the-results-in-a-new-cell?hl=en Aug 9, 2019 ... I have two spreadsheets and need to transfer data from one spreadsheet to the next. ... cells imported into ONE cell in workbook 2. If I ...
How to combine two cells with unique data only - Google Docs ...
https://support.google.com/docs/thread/146889153/how-to-combine-two-cells-with-unique-data-only?hl=en Jan 20, 2022 ... I want to combine data that is separated by commas in two columns, but I don't want to combine duplicate data. For example, one cell might say " ...
I have multiple tables in my document and would like to join them ...
https://support.google.com/docs/thread/245460715/i-have-multiple-tables-in-my-document-and-would-like-to-join-them-together-to-make-one-big-table?hl=en Nov 24, 2023 ... I have multiple tables in my document and would like to join them together to make one big table · Expand the First Table: Add enough rows to the ...
How do I combine a date cell and time cell into another cell and ...
https://support.google.com/docs/thread/65915344/how-do-i-combine-a-date-cell-and-time-cell-into-another-cell-and-retain-the-date-time-formatting?hl=en Aug 20, 2020 ... I am trying to combine a date cell with a time cell (using concatenate), but the formatting of the result becomes text and does not retain a date format.
How do I combine multiple results of two filter formulas in Sheets ...
https://support.google.com/docs/thread/83739726/how-do-i-combine-multiple-results-of-two-filter-formulas-in-sheets?hl=en Nov 18, 2020 ... I then run a second FILTER to get the wages. I get those in a list in separate cells as well. I need these combined together (ie [Arizona,54000] ...
IMPORTRANGE pulling from multiple columns into one column ...
https://support.google.com/docs/thread/201258169/importrange-pulling-from-multiple-columns-into-one-column?hl=en Feb 9, 2023 ... I am trying to combine the two inputs in a different google sheet into one column/cell. I was able to use the below breakdown to get the information for a ...
Query code is merging a few cells into one and giving flawed data ...
https://support.google.com/docs/thread/83952302/query-code-is-merging-a-few-cells-into-one-and-giving-flawed-data?hl=en Nov 20, 2020 ... I am using the query function to copy data from one sheet to another based on a particular cell value, however, the data being copied in row 2 of every sheet ...
How to combine multiple (and not continuous) columns into one ...
https://support.google.com/docs/thread/11235039/how-to-combine-multiple-and-not-continuous-columns-into-one?hl=en Aug 3, 2019 ... How to combine multiple (and not continuous) columns into one? I have a sheet that has 123 columns with the the following headers "Date ...
Unexpected merge of cells in Google Sheet when using QUERY on ...
https://support.google.com/docs/thread/80895004/unexpected-merge-of-cells-in-google-sheet-when-using-query-on-number-columns?hl=en Nov 4, 2020 ... If one of the columns contains a "number" value, and if this column has empty values for consecutive rows, it appears that every rows until the first not empty ...
How can I Merge my multi-sheet spreadsheets into one big one ...
https://support.google.com/docs/thread/5049954/how-can-i-merge-my-multi-sheet-spreadsheets-into-one-big-one?hl=en Apr 28, 2019 ... It is a pain having two separate spreadsheets. I'd used excel but never Google Sheets, so it has been a learning curve. Initially I helped him ...