Overview for Transpose Columns

Use Transpose Columns to switch columns to rows in your worksheet. For example, an exercise scientist records exercise totals for each test subject. The scientist uses Transpose Columns to rearrange the data so that the totals for each exercise are in a separate column. In the following worksheet, the original data are in columns C1–C4. Columns C5–C8 contain the transposed data.