That's easy:
Delete rows 1 to 17
Insert a new row at the top
Do a Text to columns  procedure on column A
Delete columns I to L
Insert a new column A
Add column headings in cells A1 to I1
Select the block of data  in the middle and centre the text/value
Delete the bottom 2 rows (not sure what's in there)
Number the data rows in column A 1 to x
Put an Average formula at the bottom of column B
Copy it across the bottom of the other columns
Put an X in column A on that row
Add a STDEV formula to the bottom of Column B
Copy it across the bottom of the other columns
Add 'STDEV' as text to the leftmost cell on this row.