About 1,936,303 results (5,350 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 ... One way I see of doing that is setting up several conditional formatting rules over and over. The problem is I have several dozen rows I'd like ...
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 ...
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 ...
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 ... This only works if the first cell of each row always has the same content (VP in this case), so if that is not the case, it's better to use ...
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 ... Select all your rows; Right click anywhere in the selection; Select 'Resize rows'; Check the 'Specify row height' option; Leave (or set) to 21.
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.
Split multiple cells in multiple rows from one sheet into a new sheet ...
https://support.google.com/docs/thread/248637210/split-multiple-cells-in-multiple-rows-from-one-sheet-into-a-new-sheet?hl=en Dec 15, 2023 ... Hi JuanPabloX,. Thank you for the sample file! I have placed a possible solution for you in the sheets/tabs called Help and Help2, which I have ...
Can you enter multiple data in one cell and parse them separately ...
https://support.google.com/docs/thread/7671180/can-you-enter-multiple-data-in-one-cell-and-parse-them-separately-when-referencing-the-cell?hl=en Jun 8, 2019 ... You'll get a #ref error message if you do. Adjust the range of the formula as you add/delete rows and columns. N1={"Sum";ArrayFormula(mmult ...
QUERY returning multiple rows as single row - Google Docs Editors ...
https://support.google.com/docs/thread/104005245/query-returning-multiple-rows-as-single-row?hl=en Mar 26, 2021 ... It will always be the first n number of rows of the data, and yes, they will all get "smushed" into one cell. Most often this header label ...
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 ... ... a row into multiple rows based on the contents of a single cell. ... This question is locked and replying has been disabled. I have the same ...
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 know ...
Visualising multiple "locations" in ONE cell on the map chart, how is ...
https://support.google.com/docs/thread/95705970/visualising-multiple-locations-in-one-cell-on-the-map-chart-how-is-this-possible?hl=en Jan 29, 2021 ... But these locations are pulled from another sheet where the "location" values are in ONE cell ( i can't put in separate cells as each row ...
How to split a cell horizontally? - Google Docs Editors Community
https://support.google.com/docs/thread/194899973/how-to-split-a-cell-horizontally?hl=en Dec 29, 2022 ... Hi there, I would like to split a cell horizontally in Google Sheets/Excel. ... one cell so I can have multiple rows within one cell. The purpose ...
Pasting over multiple cells not working more than once - Google ...
https://support.google.com/docs/thread/8953776/pasting-over-multiple-cells-not-working-more-than-once?hl=en Jun 29, 2019 ... I do the following frequently: I'll copy a cell (ctrl + C or Sheets ... sometimes into one cell and sometimes into multiple cells.
Splitting single row of form output into multiple rows based on how ...
https://support.google.com/docs/thread/162771021/splitting-single-row-of-form-output-into-multiple-rows-based-on-how-much-of-the-form-was-filled?hl=en May 7, 2022 ... Does this seem helpful? You only have one sample row of data, so it doesn't give very complete testing. Also, merged cells can ...
How can I paste a selection of multiple rows of text and paste into ...
https://support.google.com/docs/thread/5026864/how-can-i-paste-a-selection-of-multiple-rows-of-text-and-paste-into-single-cell-in-google-sheets?hl=en Apr 27, 2019 ... ... create multiple independent rows within one single cell in google sheets? I want 8 lines of text to be each within their own "row" type cell ...
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 ...
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 ... I am attempting to combine multiple rows into one row based on a header row. It seems like it should be very simple to put together but I have not been able to ...