About 1,652,871 results (5,514 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 ...
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 ... I keep highlighting and deleting, but they won't go away. The glide app that I am trying to develop will only accept 500 rows of data. I ...
How to combine hyperlink label and web addresses columns AND ...
https://support.google.com/docs/thread/174412254/how-to-combine-hyperlink-label-and-web-addresses-columns-and-delete-old-redundant-data-in-sheets?hl=en Aug 8, 2022 ... I do NOT want 3 columns where you keep the original redundant data ... Is there anyway to do this without Microsoft Excel, and also without going ...
How to merge multiple google docs into one but keep the original files
https://support.google.com/docs/thread/13492928/how-to-merge-multiple-google-docs-into-one-but-keep-the-original-files?hl=en Sep 3, 2019 ... At this time it's not possible to merge documents in Docs. However, there is an add-on for Google Drive that can do this.
How do I sort a list of unique data without losing the formula and ...
https://support.google.com/docs/thread/38410163/how-do-i-sort-a-list-of-unique-data-without-losing-the-formula-and-keeping-rows-together?hl=en Apr 6, 2020 ... There are two formulas that are reporting all of the data on the sheet. Columns A to D use a QUERY formula that finds all of the vet names and ...
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 to keep adjacent Grouped rows or columns separate - Google ...
https://support.google.com/docs/thread/136655905/how-to-keep-adjacent-grouped-rows-or-columns-separate?hl=en Nov 22, 2021 ... I have several sheets that utilize the Group rows/columns feature. I want to create multiple groups based on months, so each month can be ...
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 ... I've found lots of ways to merge data from one sheet to another, but he needs to keep the individual sheets. Is there an automatic or scripted ...
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 ... Each of the toned cells has a formula. I made some varied sample data with both skipped columns and 1, 2 or 3 items in a cell. Double check ...
HOW DO I TRANSPOSE GOOGLE FORM DATA AND COMBINE ...
https://support.google.com/docs/thread/29236030/how-do-i-transpose-google-form-data-and-combine-columns-and-keep-it-all-dynamic?hl=en Feb 20, 2020 ... HOW DO I TRANSPOSE GOOGLE FORM DATA AND COMBINE COLUMNS AND KEEP IT ALL DYNAMIC? ... Also indicate how you want the data sorted for multiple techs ...
BUG: Google Sheets merging empty cells without asking - Google ...
https://support.google.com/docs/thread/23857911/bug-google-sheets-merging-empty-cells-without-asking?hl=en Dec 26, 2019 ... This merging messes up formatting, such as removing duplicates or dynamic manipulation of the data with functions. Pictures below explain ...
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 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 ... i believe i can give you a single formula, maybe two in a new tab that will display your data the way you want automatically. Three questions/ ...
Combining multiple tabs without creating duplicates - Google Docs ...
https://support.google.com/docs/thread/43406970/combining-multiple-tabs-without-creating-duplicates?hl=en Apr 29, 2020 ... There needs to be an aggregate formula for that query to work and I find count works fine. You can just hide the column too. That's just how I ...
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 ... ... keep it all in the one file. The data will be for viewing only ... If data retrieves fine but column labels are missing, make sure that ...
How to concatenate a specific column ONLY in a query between two ...
https://support.google.com/docs/thread/184455563/how-to-concatenate-a-specific-column-only-in-a-query-between-two-sets-of-data?hl=en Oct 17, 2022 ... I work at a university and am trying to compile two sets of data regarding whether or not students need one or both of a set of combined courses.
using wuery(importrange) to combine data from multiple ...
https://support.google.com/docs/thread/98092606/using-wuery-importrange-to-combine-data-from-multiple-spreadsheets?hl=en Feb 15, 2021 ... So I split the IMPORTRANGEs into two, once for the first three columns ... data from the various/separate spreadsheets into one tab without ...
Is there a way I can merge spreadsheets together without losing ...
https://support.google.com/docs/thread/25896767/is-there-a-way-i-can-merge-spreadsheets-together-without-losing-references?hl=en Jan 16, 2020 ... Take the two spreadsheets that you want to merge. Establish one of ... One way to deal with these named ranges is to open the Data ...
w97: merging columns but not rows
https://groups.google.com/g/microsoft.public.word.tables/c/UcaVJ0zbH7g to select columns and combine them into one mono-column without losing the ... 4) Using Excel or Access as her mail merge database (an idea I strongly
How to use multiple filters at the same time? - Google Docs Editors ...
https://support.google.com/docs/thread/160139208/how-to-use-multiple-filters-at-the-same-time?hl=en Apr 16, 2022 ... In other words, Columns A & B sort together without affecting Columns C & D, and vice versa. I was able to get a filter to work on each pair of ...