I would suggest this if you are simply copying to a new sheet.

=query('Form Responses'!A:G, "SELECT * ")

Syntax QUERY(data, query, [headers])

The 'Form Responses'!A:G, is the data range of the source sheet that you would like to draw data from.

The "Select * ", is the query and will select everything within the range defined previously in the same order.

I did not know this when I first started using Query so I will share. If you want to select specific columns but reorder them plus leave other columns out, you can do this by getting specific with your SELECT

ie. You have Data in Columns A:F but you want to leave D and F out and put E before C in your new sheet, You can use this "SELECT A,B,E,C"

You can read more about it here its quite powerful.

You can format the new sheet to your hearts delight and it will always update when you enter new data. As long as you have data in the range you've defined in the query.

Short answer

1. Add a new sheet.
2. Add the following formulas to the new sheet

Cell A2 -> Headers

=OFFSET('Form responses 1'!$A$2,ceiling((row()-1)/5,1)-1,0)  

This could be repeated several times, one for each header column, just change the last parameter accordingly.

Cell B2 -> data

=OFFSET('Form responses 1'!$A$2,ceiling((row()-1)/5,1)-1,mod(row()-2,5)*2+1,1,2)

Fill down as necessary

Explanation

• OFFSET() is used to get the values from the source data.
• 'Form responses 1'!$A$2 is the start point to count columns and rows.
• row() is used to increment the row and column iterators.
• ceiling((row()-1)/5,1), row iterator, is used to set the row from the source data.
• mod(row()-2,5)*2+1, column iterator, is used to set the column from the source data.
• In the data formula the last parameter, indicates the number of data columns.

In case that are several "header data" columns, add 1 for each of them. I.E. if there are five "header data" columns, and six "data columns" the column iterator should be

mod(row()-2,5)*6+5

The final data formula to be added to the F2 cell is:

=OFFSET('Form responses 1'!$A$2,ceiling((row()-1)/5,1)-1,mod(row()-2,5)*6+5,1,6)

In the row and column iterators, 5 is used because there are 5 columns for "record data".

Demo

Spreadsheet