About 1,538,279 results (1,912 milliseconds)
Query code is merging a few cells into one and giving flawed data ...
https://support.google.com/docs/thread/83952302/query-code-is-merging-a-few-cells-into-one-and-giving-flawed-data?hl=en Nov 20, 2020 ... I am using the query function to copy data from one sheet to another based on a particular cell value, however, the data being copied in row 2 of every sheet ...
Combine rows into a single row - Google Docs Editors Community
https://support.google.com/docs/thread/97596955/combine-rows-into-a-single-row?hl=en Feb 10, 2021 ... Hi Stefan,. Seems like a proper example could really smooth this whole thing up! :) Here's a solution in the new tab called MK.Idea in cell P2.
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 ... ... rows below? I have a spreadsheet where data is coming in daily in rows below the existing content, and I need it to be an array formula ...
Explain using arrayformula from joining multiple cells into one cell ...
https://support.google.com/docs/thread/222792788/explain-using-arrayformula-from-joining-multiple-cells-into-one-cell-that-share-a-unique-key-column?hl=en Jun 26, 2023 ... no matter what i've tried, it always results in only a single row being filled or an error message popping up. After searching for solutions, I ...
IMPORTHTML, listing rows in one cell with delimiter - Google Docs ...
https://support.google.com/docs/thread/156878967/importhtml-listing-rows-in-one-cell-with-delimiter?hl=en Mar 23, 2022 ... Hi Robert,. It is unclear why you would want to combine the values into one cell if your intention is to break the values into rows again.
Combine Rows into Expanded Columns - Google Docs Editors ...
https://support.google.com/docs/thread/189751279/combine-rows-into-expanded-columns?hl=en Nov 22, 2022 ... This question is locked and replying has been disabled. I have the same question (0).
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 ... Please see the tab pkv_test for the following formula in cell A1 and a pivot table based on its result in cell F1. =ArrayFormula({"event_name ( ...
Concatenate Data into One Cell From Array - Google Docs Editors ...
https://support.google.com/docs/thread/179167029/concatenate-data-into-one-cell-from-array?hl=en Sep 13, 2022 ... Normaly, I would make an array formula that does not need to be in every row but you hit the character limit of combining text very easily, so I ...
Help with Query, Concatenate, & Importrange - Google Docs Editors ...
https://support.google.com/docs/thread/202128397/help-with-query-concatenate-importrange?hl=en Feb 15, 2023 ... Right now it's pulling everything into one cell as opposed to having it fill in down the rows appropriately. Any insight would be greatly ...
How to merge data from multple rows of spreadsheet into one ...
https://support.google.com/docs/thread/93656507/how-to-merge-data-from-multple-rows-of-spreadsheet-into-one-google-doc?hl=en Jan 15, 2021 ... I have a spreadsheet with multiple lines of data for each student. I want to be able to merge this into a single Google Doc for each student.
Joining of record file rows into one row
https://groups.google.com/g/openrefine/c/Ss-JoVM_VpM I am having a file that contains a lot of records in it and when I export these records as .XSL format, one record is split into multiple rows in an Excel ...
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 ... ... rows, so there can only be 150,000 or so cells, and all of the sheets would easily fit in one spreadsheet. I've found lots of ways to merge ...
How can you pull specific rows from several separate sheets and ...
https://support.google.com/docs/thread/73038234/how-can-you-pull-specific-rows-from-several-separate-sheets-and-organize-them-into-one-sheet?hl=en Sep 24, 2020 ... How can you pull specific rows from several separate sheets and organize them into one sheet? ... combine the data for the two teachers into the ' ...
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 want to be able to select the multiline text and paste it into one cell in Google Sheets while keeping the original text's formatting. I know ...
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 would like to merge these cells into one cell, and add a comma between them (ex: Doe, John). How do I do this easily without losing the contents of the 2nd ...
Google Sheets combine rows together - how to with formulas ...
https://support.google.com/docs/thread/268495319/google-sheets-combine-rows-together-how-to-with-formulas?hl=en Apr 9, 2024 ... You can try this formula in cell A2 in a blank sheet: =ArrayFormula(LET(range, HSTACK(CURRENT!A3:E, CURRENT!H3:H), agg, QUERY(QUERY(HSTACK ...
Combine cells into one cell with line breaks - Google Docs Editors ...
https://support.google.com/docs/thread/157314891/combine-cells-into-one-cell-with-line-breaks?hl=en Mar 26, 2022 ... The course choice per student is listed in column N. I have split the course items from column N with a SPLIT formula into columns AA to AT. I ...
Concatenate values from multiple cells in a column to a single cell ...
https://support.google.com/docs/thread/18680205/concatenate-values-from-multiple-cells-in-a-column-to-a-single-cell?hl=en Nov 5, 2019 ... I've added some formulas to your Worksheet2 Column C that concatenates your entries in Sheet1A by ID into one line, separated by comma for each value.
Combine rows into single row but data in the rows can contain any ...
https://support.google.com/docs/thread/206093579/combine-rows-into-single-row-but-data-in-the-rows-can-contain-any-type-of-string-with-spaces?hl=en Mar 14, 2023 ... The formulas are in cells N3:N7 . The results will exactly match the desired results you show by value, but the formatting of date and date time ...
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 ... I am creating an intervention tracking sheet. I want one column header to be "Week 1" and in the cell under it have five smaller cells that ...