PiscesLogoSmallerStill  Transposing data

Top  Previous  Next

Use this option to switch the rows and columns of the data set. Like all the other adjustments it is applied to the working data set. Select Transpose in the Type of Adjustment radio box and click on the Submit button.


The normal arrangement of community data within CAP is to have the samples (quadrats) as columns and the variables (e.g. species) as the rows. However, old versions of Excel had a maximum number of columns of 255, which can prove difficult if you have a data set with a very large number of sites/samples. If this is the case, the data can be arranged in Excel with the species forming the columns, and the Transpose option within CAP used to switch columns and rows.


N.B. If you have allocated your samples to groups, for the purposes of using the ANOSIM or SIMPER methods, you will find that your groups will be lost if you transpose your data. The solution is to save your working data using File:  Export, then reload the data into CAP; you can then re-assign samples to groups.