<?xml version="1.0" encoding="utf-8"?><!DOCTYPE article  PUBLIC '-//OASIS//DTD DocBook XML V4.4//EN'  'http://www.docbook.org/xml/4.4/docbookx.dtd'><article><articleinfo><title>FAQ/transp</title><revhistory><revision><revnumber>2</revnumber><date>2013-03-08 10:17:15</date><authorinitials>localhost</authorinitials><revremark>converted to 1.6 markup</revremark></revision><revision><revnumber>1</revnumber><date>2010-03-23 12:30:21</date><authorinitials>PeterWatson</authorinitials></revision></revhistory></articleinfo><section><title>What does the TRANSPOSE ALL DATA option in the RESTRUCTURE menu do in SPSS?</title><para>Transposing all data simply makes the rows the columns and the columns the rows. For example </para><informaltable><tgroup cols="3"><colspec colname="col_0"/><colspec colname="col_1"/><colspec colname="col_2"/><tbody><row rowsep="1"><entry align="center" colsep="1" nameend="col_1" namest="col_0" rowsep="1"><para> 1 </para></entry><entry colsep="1" rowsep="1"><para> 4 </para></entry></row><row rowsep="1"><entry align="center" colsep="1" nameend="col_1" namest="col_0" rowsep="1"><para> 2 </para></entry><entry colsep="1" rowsep="1"><para> 5 </para></entry></row><row rowsep="1"><entry align="center" colsep="1" nameend="col_1" namest="col_0" rowsep="1"><para> 3 </para></entry><entry colsep="1" rowsep="1"><para> 6 </para></entry></row></tbody></tgroup></informaltable><para>becomes, after transposing, </para><informaltable><tgroup cols="5"><colspec colname="col_0"/><colspec colname="col_1"/><colspec colname="col_2"/><colspec colname="col_3"/><colspec colname="col_4"/><tbody><row rowsep="1"><entry align="center" colsep="1" nameend="col_2" namest="col_0" rowsep="1"><para> 1 </para></entry><entry colsep="1" rowsep="1"><para> 2 </para></entry><entry colsep="1" rowsep="1"><para> 3 </para></entry></row><row rowsep="1"><entry align="center" colsep="1" nameend="col_2" namest="col_0" rowsep="1"><para> 4 </para></entry><entry colsep="1" rowsep="1"><para> 5 </para></entry><entry colsep="1" rowsep="1"><para> 6 </para></entry></row></tbody></tgroup></informaltable><para>and vice-versa so that the transpose of a transposed data set is the original data set. This is not usually of use as similar operations on  <emphasis>subsets</emphasis> of columns of the data, rather than all columns, is usually required and this can be carried out using the other two options in the RESTRUCTURE menu which correspond to VARSTOCASES or CASESTOVARS commands. These latter two options are hence more flexible than the transpose all data option. </para></section></article>