Example of the TRANSPOSE Function
To illustrate the TRANSPOSE function, we’ll use a simple table that lists several months and the number of family birthdays in each month. See the screenshot below. (Click any image for a larger view.)
In this example, we have a table that is 7 rows by 2 columns, and we would like to transform it into one that is 2 rows by 7 columns.
Step 1: First, we need to select the cells in which we want the transformed cells to appear. In this case, we need to select a group of cells on the worksheet that is 2 rows high by 7 columns long.
Step 2: With these cells selected, click on the formula bar in the area shown in the screenshot below.
Step 3: Type in the formula containing the TRANSPOSE function. Since the initial table that we want to transpose is in cells A1 through B7, our array is A1:B7. Even though we will need the braces eventually, don’t worry about that just yet. We’ll explain that in a moment. For now, type in the main part of the TRANSPOSE function as shown below, but don’t hit the Enter key yet.
Step 4: Once the formula is typed in, hit Ctrl + Shift + Enter instead of just Enter. This will place the braces around the formula and evaluate it in the worksheet as shown below.
Note that the TRANSPOSE function only copies the data from the cells in the initial array. If you had applied any special formatting to those cells, you will need to do that again.
Additional Resources: If you’re looking for other Excel tutorials, be sure to browse through the ever-growing library of users guides found here on Bright Hub’s Windows Channel, including the collection covering charts and graphs.