I don't have an answer to this, but I'm looking for a similar result.

I work at a campground with my wife, and she's looking for this:

1: We have a questionnaire on our website, asking for information about the child they want to send to camp.

2: When questionnaire is answered, the responses go into a Google Sheet, as horizontal lines. (Header with each individual questionnaire becoming it's own line, in turn)

3: So far, so good. This process is working as expected. I can export the Google Sheet, and save it as a document locally.

4: Here's the issue: My wife would like to have all of those individual horizontal lines exported to a NEW spreadsheet, into two vertical columns, on individual tabs in the destination spreadsheet. Example:

4A: Header row (row 1 and row 2) exports EACH TIME to Header COLUMN (Column A), with the next row (row 2 or row 3 or row 4, et al) exporting to the next tab in a vertical arrangement, so 1,2 becomes A1.

4B: The next tab created automatically, would contain row 1 and row 3, with Column 1 containing the information from Row 1 (the header row) and Column 2 containing the information from Row 3.

4C: The next tab created automatically, would contain row 1 and row 4, with Column 1 containing the information from Row 1 (the header row) and Column 2 containing the information from Row 4.

4D: And so on, and so forth.......

PLEASE assist me in this! LOL I also have ZERO idea how to actually implement the code, so some assistance there would also be EXCEPTIONALLY helpful!