Home |
Search |
Today's Posts |
#1
|
|||
|
|||
transposting data
Hi
I am having a terrible time trying to transpose horizontal data with vertical datsa. I have survey results with 288 questions and 35 respondents currently I have the respondents running horizontally with the questions running vertically; I am planning on importing the data into SPSS and need the question fields across the top and the respondents down the side. All help gratefully received Soozle |
#2
|
|||
|
|||
Soozle
Unfortunately the limitation of 256 collumns prevents you from transposing 288 rows into columns. If no greater than 256 rows you could select and copy the data then move to a new sheet and Paste SpecialTransposeOKEsc. Gord Dibben Excel MVP On Mon, 26 Sep 2005 20:42:19 GMT, "Soozle" wrote: Hi I am having a terrible time trying to transpose horizontal data with vertical datsa. I have survey results with 288 questions and 35 respondents currently I have the respondents running horizontally with the questions running vertically; I am planning on importing the data into SPSS and need the question fields across the top and the respondents down the side. All help gratefully received Soozle |
#3
|
|||
|
|||
"Gord Dibben" <gorddibbATshawDOTca wrote in message ... Soozle Unfortunately the limitation of 256 collumns prevents you from transposing 288 rows into columns. If no greater than 256 rows you could select and copy the data then move to a new sheet and Paste SpecialTransposeOKEsc. Gord Dibben Excel MVP Thanks for your help Gordon I am hoping that this will not cause too many problems importing into SPSS or maybe it can be transposed in SPSS Soozle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |