google-sheetsconcatenationtransposearray-formulasgoogle-sheets-query
Concatenate data from duplicate IDs into a single row in Google Sheets
I'm collecting responses from a Google Form where each user has an ID and can send multiple form responses. I'd like to have only one row for each ID and concatenate multiple form responses into one row containing all that ID's data.
I illustrated my question in the link below.
Solution
try:
=ARRAYFORMULA(TRIM(SPLIT(TRANSPOSE(QUERY(QUERY(SPLIT(TRANSPOSE(SPLIT(QUERY(TRANSPOSE(QUERY(
IF(C2:G<>""; "♦"&A2:A&"♥"&B2:B&"♥♠"&C2:G&"♥♠"; );;99^99));;99^99); "♦")); "♠");
"select max(Col2) group by Col2 pivot Col1");;99^99)); "♥")))
- Skip formula if sheet does not exist in Google Sheets
- In Google sheets how can I Script the manipulation of the default Zoom?
- Google Sheets IMPORTDATA for xlsx files
- conditional formatting to highlight the highest value in a row compared to all the columns before it
- Google sheets summation formula, iterating until a new header on column A
- Using ARRAYFORMULA and INDIRECT to iterate rows and return as a block
- How to scroll to bottom of a google spreadsheet using selenium
- Calculate average days between dates continuously updating
- Conditional formatting in Google Sheets is recognizing some cell values that equal 0, not others
- Model / Year formula fails when a sequence starts stops then starts again
- Google Sheets: Sumif formula
- Randomize cells in Google Sheets
- Google script for move rows depending on checkbox - Google sheet
- How do I splitTextToColumns only for cells containing commas in Google Apps Script?
- Getting a “Google hasn’t verified this app” warning when creating a trigger - ok to ignore it?
- Count in specific ways in Google sheets
- Fixing 1 row, and leaves each following row movable
- How to pass a range as a function parameter?
- Auto pulling a value in a formula to the next value in Google Sheets
- How to Extend a Formula to Apply to All Rows Using MAP or ARRAYFORMULA?
- Google Sheet - copy range if match
- shortest formula to get the last non zero value from column
- Copying data from a sheet to another with conditions
- How can I automatically generate due dates in Google Sheets based on payment plans?
- If one cell IS NOT EMPTY put text on another cell in Google Sheets
- How can I create a simple duplicate detector?
- Authorization is revoked every week. How to maintain persistent authorization?
- Conditional borders in Google Sheets
- Automatically adding a row to a sheet with data from another sheet once every day
- Adding borders based on grouped rows and conditional formatting in Google Sheets