About 1,591,606 results (3,516 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 ... I have a Google Sheet with data imported from Forms. It lists names in two separate columns (last and first). I would like to merge these ...
Combine Data from multiple sheets based on a specific criteria that ...
https://support.google.com/docs/thread/158026811/combine-data-from-multiple-sheets-based-on-a-specific-criteria-that-is-unique-for-each-student?hl=en Mar 31, 2022 ... Duplicate the sheet. · Select all cells by clicking the gray box above the row number column. · Copy the formula results as static values with ...
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 ... ... Excel since I really don't have any need for it normally. ... The glide app that I am trying to develop will only accept 500 rows of data.
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 ... I have a number of columns with data on worksheet "leaf3". · In B7 (and further down) I have a formula that combines column B and C with a dash ...
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 " ...
Function to Combine Data in Multiple Cells on one Sheet to a Single ...
https://support.google.com/docs/thread/12617867/function-to-combine-data-in-multiple-cells-on-one-sheet-to-a-single-cell-on-another-sheet?hl=en Aug 23, 2019 ... I've tried Importrange, Query, Join, TextJoin. I'm familiar with formulas in Excel, just not these. The first tab is the way I'd like the ...
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&" > , "))".
How can I combine multiple IMPORTRANGE with QUERY to SUM ...
https://support.google.com/docs/thread/205825089/how-can-i-combine-multiple-importrange-with-query-to-sum-data-from-another-spreadsheet?hl=en Mar 12, 2023 ... ... data outside of a workbook because the workbook was starting to hit cell limitations. Now I want to send some of the data from the new ...
Consolidate multiple columns of data into one column in a new tab ...
https://support.google.com/docs/thread/79821686/consolidate-multiple-columns-of-data-into-one-column-in-a-new-tab?hl=en Oct 29, 2020 ... I need to pull all of those names from their multiple columns into a single column in a new tab, and sort them alphabetically.
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 ... The final cell should include all of the names of the fish, but also remove duplicate values of the fish if they appear in multiple columns.
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 ...
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 ...
How do you consolidate multiple tabs on Sheets into one Master list ...
https://support.google.com/docs/thread/8201106/how-do-you-consolidate-multiple-tabs-on-sheets-into-one-master-list?hl=en Jun 17, 2019 ... ... columns that have text in some cells and numbers in other cells. Mixed data columns in QUERY() will only include the most common data so if ...
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 ... onto A3:A. However, is there a way to ignore the empty fields? The way it's working now is creating thousands of extra fields for the data that ...
I need to extract data from multiple columns based on the date ...
https://support.google.com/docs/thread/27901873/i-need-to-extract-data-from-multiple-columns-based-on-the-date?hl=en Feb 6, 2020 ... Your current structure of adding data to individual sheets/tabs and then looking to combine them into one larger sheet is the opposite of how ...
Unique Combinations from multiple columns - Google Docs Editors ...
https://support.google.com/docs/thread/100385323/unique-combinations-from-multiple-columns?hl=en Mar 1, 2021 ... The whole process is based on the fact that if you combine a row of data with a column of data, you get one value for each row and each column.
How Merge/Combine data from different tables - Google Docs ...
https://support.google.com/docs/thread/305223321/how-merge-combine-data-from-different-tables?hl=en Nov 1, 2024 ... Most of the tutorials show how to merge tables with the same rows or columns. Google Sheet has a Pivot Tabel feature, but it only works with one table on one ...
Combine the data from multiple sheets into 1 master sheet but ...
https://support.google.com/docs/thread/102572299/combine-the-data-from-multiple-sheets-into-1-master-sheet-but-exclude-some-columns?hl=en Mar 16, 2021 ... For each bank account I have broken that into 2 columns - "Amount" and then "Running Balance". There is 4 different sheets that are all the ...
Sorting and combining data from two separate sheets into one sheet ...
https://support.google.com/docs/thread/78963756/sorting-and-combining-data-from-two-separate-sheets-into-one-sheet-by-date?hl=en Oct 25, 2020 ... I am currently trying to add two different google sheets together on a different sheet and then sort that by one of the columns (the date).
Form Responses: Combine/Group columns and Split data into ...
https://support.google.com/docs/thread/171294317/form-responses-combine-group-columns-and-split-data-into-different-rows?hl=en Jul 15, 2022 ... Then I tried to use the new grouped column to split the data into multiple rows. I found this formula in another response and tried to mimic it:.