About 1,705,215 results (4,287 milliseconds)
How to add multiple cells in one cell - Google Docs Editors Community
https://support.google.com/docs/thread/180701721/how-to-add-multiple-cells-in-one-cell?hl=en Sep 23, 2022 ... The correct method is to create narrow columns. Each of the narrow columns will appear as smaller cells. Then you select 5 cells above and merge those cells.
Conditional formatting with multiple rows and checkboxes - Google ...
https://support.google.com/docs/thread/179163544/conditional-formatting-with-multiple-rows-and-checkboxes?hl=en Sep 13, 2022 ... Just like if you put =$B2=TRUE in cell C2 and copy/pasted it into C3 it would become =$B3=TRUE. It checks every cell aginst your custom formula ...
Google Sheet formula to move texts in one row to multiple rows ...
https://support.google.com/docs/thread/127394481/google-sheet-formula-to-move-texts-in-one-row-to-multiple-rows?hl=en Sep 23, 2021 ... I can't think of a single ArrayFormula that will do this? Let us see first if someone else offers a soltion. Ben Liebrand.
Shift values in multiple rows
https://groups.google.com/g/openrefine/c/qLgNiCM0MDE I have a large dataset in OpenRefine and I need to shift a value down by one cell - in multiple rows. For example: Name Age. Mary 20. Sam. Abigail. Kim 10. Tom.
Is there a way to make rows with multiple lines of text only show a ...
https://support.google.com/docs/thread/240451229/is-there-a-way-to-make-rows-with-multiple-lines-of-text-only-show-a-single-line-of-text?hl=en Oct 23, 2023 ... The only other option I can think of would be to make the columns that tend to get more than one line of text their own row below the other rows ...
SPLITTING THE DATA COLLECTED IN FORMS FROM ONE CELL ...
https://support.google.com/docs/thread/66000956/splitting-the-data-collected-in-forms-from-one-cell-to-multiple-rows-in-sheets?hl=en Aug 20, 2020 ... SPLITTING THE DATA COLLECTED IN FORMS FROM ONE CELL TO MULTIPLE ROWS IN SHEETS ... This question is locked and replying has been disabled. I have ...
Is there a way to paste multiple lines of text into one cell and keep ...
https://support.google.com/docs/thread/221785335/is-there-a-way-to-paste-multiple-lines-of-text-into-one-cell-and-keep-the-formatting?hl=en Jun 20, 2023 ... I have a source document with formatted text over multiple lines. I want to be able to select the multiline text and paste it into one cell ...
Separating the lines of data in a cell to individual rows? - Google ...
https://support.google.com/docs/thread/4839994/separating-the-lines-of-data-in-a-cell-to-individual-rows?hl=en Apr 24, 2019 ... You'll want to use the SPLIT function with a delimiter of CHAR(10), the line feed character. The formula for multiple rows would be something like.
Combine multiple rows into one row based on header row - Google ...
https://support.google.com/docs/thread/163884521/combine-multiple-rows-into-one-row-based-on-header-row?hl=en May 17, 2022 ... This question is locked and replying has been disabled. I have the same question (1) ... cell A1 and a pivot table based on its result in cell F1.
Need help with a formula that has multiple criteria. I think it needs ...
https://support.google.com/docs/thread/58086012/need-help-with-a-formula-that-has-multiple-criteria-i-think-it-needs-more-than-a-if-and-function?hl=en Jul 9, 2020 ... ... formula to work with only one row or multiple rows. Mchall's solution is one way that you could use the calculator on one row of data. If ...
How to split a row into multiple rows based on the contents of a ...
https://support.google.com/docs/thread/201099683/how-to-split-a-row-into-multiple-rows-based-on-the-contents-of-a-single-cell?hl=en Feb 8, 2023 ... How to split a row into multiple rows based on the contents of a single cell. ... I have the same question (15). Subscribe. Community content ...
Creating multiple new rows in new sheet based on column data ...
https://support.google.com/docs/thread/139563876/creating-multiple-new-rows-in-new-sheet-based-on-column-data?hl=en Dec 9, 2021 ... The semi-colons put the next pair on the next row. You can join multiple ranges from your Sheet into one continuous range using this same ...
Create multiple rows based on Cell Values in 2 columns - Google ...
https://support.google.com/docs/thread/75794351/create-multiple-rows-based-on-cell-values-in-2-columns?hl=en Oct 8, 2020 ... I have one further question, is it possible to add a condition to this formula? Say if there is a 3rd column, with value Yes, then generate rows ...
Only importing rows where the first cell value matches a cell value ...
https://support.google.com/docs/thread/52385420/only-importing-rows-where-the-first-cell-value-matches-a-cell-value-from-an-existing-sheet?hl=en Jun 9, 2020 ... I have a master list of all projects for my entire group with their respective project numbers listed in the leftmost column on one sheet that ...
How do I autofill dates one week apart across multiple rows ...
https://support.google.com/docs/thread/204689885/how-do-i-autofill-dates-one-week-apart-across-multiple-rows?hl=en Mar 4, 2023 ... Ideally I would like to have the start date (2/27/23) and end date (3/5/23) within one cell, but I'd be okay with two separate columns. I ...
How to separate a single row into multiple rows? - Google Docs ...
https://support.google.com/docs/thread/235917206/how-to-separate-a-single-row-into-multiple-rows?hl=en Sep 21, 2023 ... I have a dynamic list generated from a Google form. The spreadsheet the form generated contains one row of students data for each teacher and ...
Distinct Drop Down in multiple rows AND columns? - Google Docs ...
https://support.google.com/docs/thread/134303955/distinct-drop-down-in-multiple-rows-and-columns?hl=en Nov 7, 2021 ... ... one very long column of data. This data is then ... Otherwise, can it highlight duplicates and make the cell red if a duplicate is found?
How do I Insert Multiple Rows in spreadsheet easily - Google Docs ...
https://support.google.com/docs/thread/1955600/how-do-i-insert-multiple-rows-in-spreadsheet-easily?hl=en Mar 1, 2019 ... What you can do is to select multiple rows on the row number column ... one empty cell - it will split into the two cells. PLEASE note: if ...
Quickest way to search multiple rows/columns at once for a single ...
https://support.google.com/docs/thread/208630346/quickest-way-to-search-multiple-rows-columns-at-once-for-a-single-true-false-match?hl=en Mar 30, 2023 ... ... cells that contain the value TRUE, you would use the following formula: =FILTER(range, TRUE). This formula would return a range of cells that ...
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 ... But when I try to create two groups that are adjacent to each other, they turn into one big group instead. Ex. rows 1-10 are September, rows 11- ...