About 1,879,019 results (1,812 milliseconds)
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 ...
Concatenate + remove duplicate data in multiple columns for every ...
https://support.google.com/docs/thread/157888924/concatenate-remove-duplicate-data-in-multiple-columns-for-every-value-that-matches-in-column-a?hl=en Mar 30, 2022 ... When an email address matches in SOURCE tab of Column A, I want to consolidate Column D & Column E, with their respective values separated by a space and a ...
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 ...
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 ... Im trying to combine multiple tabs into one master sheet. The tabs are made up of years (2021, 2022, 2023) and I'd like to be able to make changes to a tab.
Combine Col B when Col A has duplicates? - Google Docs Editors ...
https://support.google.com/docs/thread/123221749/combine-col-b-when-col-a-has-duplicates?hl=en Aug 27, 2021 ... I would like to find a way to combine the info in column B into one cell when column A has duplicates. Preferably with each duplicate beneath the other in the ...
How can I avoid Pandas merge creating duplicates
https://groups.google.com/g/pydata/c/eOOtVoRGH3c I've been reconciling sales data between two systems using Excel's Power ... But, if you say that you get duplicated entries in the merged results, that means ...
How do I count up values while excluding duplicates from other ...
https://support.google.com/docs/thread/99182081/how-do-i-count-up-values-while-excluding-duplicates-from-other-ranges?hl=en Feb 21, 2021 ... But it does bypass the use of the column of "Y"s, if that is a concern. Like JonM, I merged the name fields, and then used them twice in a QUERY ...
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 ... ... rows attached the bottom of the first table. I basically just need to join each table so that the bottom row of each table joins to the top ...
Merging form answers from different sections into the same column ...
https://support.google.com/docs/thread/157220815/merging-form-answers-from-different-sections-into-the-same-column-for-a-linked-spreadsheet?hl=en Mar 25, 2022 ... Right now I only have 2 school's unique 2nd sections setup and before I keep building out the other 18 I want to be sure I can get the responses ...
clear all filter in google sheets - Google Docs Editors Community
https://support.google.com/docs/thread/3476500/clear-all-filter-in-google-sheets?hl=en Apr 2, 2019 ... On a whim, I unmerge two of the merged cells and try to merge them back together. ... I switched to Microsoft Excel. Alex Ivanov ✓. Gold ...
Merging form answers from different sections into the same column ...
https://support.google.com/docs/thread/95751354/merging-form-answers-from-different-sections-into-the-same-column-for-a-linked-spreadsheet?hl=en Jan 29, 2021 ... I was wondering if it was possible to have multiple sections with near-identical questions but different data validation, feed into the same ...
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 ...
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 ...
Removing duplicated words within a cell - Google Docs Editors ...
https://support.google.com/docs/thread/85472169/removing-duplicated-words-within-a-cell?hl=en Nov 26, 2020 ... Here's a fix of the idea you were working with: Edited even Shorter! =Join(" ", sort(Unique( ...
When unmerging is it possible to populate individual cells with the ...
https://support.google.com/docs/thread/104761136/when-unmerging-is-it-possible-to-populate-individual-cells-with-the-same-data-as-in-the-merged-cell?hl=en Apr 2, 2021 ... Apr 2, 2021 ... It's ok for centering up graphic labels that sit above a table for example, but merged cells are a disaster when applied to data ...
How do I make multiple sections in a Form combine into one column ...
https://support.google.com/docs/thread/160368685/how-do-i-make-multiple-sections-in-a-form-combine-into-one-column-in-a-sheet?hl=en Apr 18, 2022 ... I'm trying to edit the formula in a new sheet right now, but I have attached a duplicate sheet for the purpose of support below. https://docs.
Remove Duplicates - Google Workspace Marketplace
https://workspace.google.com/marketplace/app/remove_duplicates/347814268012 Feb 12, 2025 ... 5️⃣ Compare columns Compare two columns from one Google sheet for matches or differences in just one step. 6️⃣ Combine duplicate rows Merge cells ...
Checking for duplicates across multiple tabs in one Google Sheet ...
https://support.google.com/docs/thread/216004482/checking-for-duplicates-across-multiple-tabs-in-one-google-sheet?hl=en May 16, 2023 ... ... Column B of all these 8 tabs, to check for any duplicate values. ... The additional tab is used to consolidate all the column B's in all the other ...
How To Merge Data From Multiple Rows into one Cell - with ...
https://support.google.com/docs/thread/54624016/how-to-merge-data-from-multiple-rows-into-one-cell-with-formatting?hl=en Jun 20, 2020 ... I need to be able to scan for Rows of a specific date, and then be able to merge the info on columns Time, ID, and Lead for each row - and then combine the ...
Power Tools - Google Workspace Marketplace
https://workspace.google.com/marketplace/app/power_tools/1058867473888 Jan 20, 2025 ... ... duplicates or merge two tables in a click. ... - Scenarios are finally available for the following add-ons: Merge Sheets, Remove Duplicate Rows, ...