Columns and rows display change
Assuming your data:
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
is parsed in the range A1 to D7(for example), isn't it just a matter of
copying B1:D7 and then doing a PasteSpecial, Transpose?
--
Jim
"fascal" wrote in message
...
| 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?
|