Below in my query result:

Snapshot of Google Sheets

In the above table "Form Response" table is the response received in Google Sheets from Google Form.
I want to convert "Form Response" table to "Desired Result" Table.
I used FLATTEN & SPLIT functions to convert column Card data with one name in one cell.
I manually entered Timestamp date in Desired Result Table.

I need the Timestamp information automatically in Desired Table

1 Answer 1


You can use

  INDEX(FLATTEN(SPLIT(REPT(QUERY(A2:A," where A is not null ",0)&"@",3),"@"))),
  INDEX(FLATTEN(SPLIT(QUERY(B2:B," where B is not null ",0),",")))}

enter image description here

Functions used:

  • Please remember that you can also contribute to this community that helps you. As per site guidelines when an answer addresses your question, accept it and even upvote it so others can benefit as well. Feb 18, 2021 at 12:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.