Hi,

I have the following set up. The survey data is downloaded form an Access
database into a csv file. I save it as an *.xls file.

The questions are the column headings; the rows are the blocks in which the
survey was taken. (example below). There can only be a maximum of 16
responses per block.

block q1 q2 q3
'19-2007 4 4 5
'19-2007 3 3 3
'19-2007 2 2 3
'19-2007 5 4 5
'19-2007 4 2 4
'19-2007 4 4 4

I want to program the worksheet to transfer the data from this format to
another sheet in the format below:

Responses:
q1 4 3 2 5 4 4

q2 4 3 2 4 2 4

q3 5 5 5 5 5 5

Does anyone know the VBA I would use to perform such a function?