Note: If a table provides the source data for a pivot table in your spreadsheet, or if the table is in a spreadsheet that’s shared with others, the table can’t be transposed.Ĭhoose Table > Transpose Rows and Columns (from the Table menu at the top of your screen).
Restore an earlier version of a spreadsheet. Save a large spreadsheet as a package file. See the latest activity in a shared spreadsheet. Place objects inside a text box or shape. Format Chinese, Japanese, or Korean text. Use a keyboard shortcut to apply a style. Create, rename, or delete paragraph styles. Bold, italic, underline, and strikethrough. Format a spreadsheet for another language. Select text and place the insertion point. Change the look of chart text and labels. Add a legend, gridlines, and other markings. Add column, bar, line, area, pie, donut, and radar charts. Calculate values using data in table cells. Quickly calculate a sum, average, and more. 
View the source data for a pivot table value. Change how pivot table data is sorted, grouped, and more. Add calculations to summarize group data. Add checkboxes and other controls to cells. Use VoiceOver to create formulas and autofill cells. Intro to images, charts, and other objects. This second method has a bit more work to it, but once you get a hang of it, it will prove to be easier and faster than the first method. 
There is another way of converting your table’s rows into columns. You can now paste it into its original location or use it somewhere else. So, if you have followed the tutorial by creating a table from our example, you should end up having the following result.Īnd that’s all – you’ve successfully transposed your starting table.
Your table will appear with its rows converted into columns. Once you have selected the field, right-click on it and select Paste special > Transposed. We will click on the empty A9 field and convert the table there, just so that you can compare the result with the original easier. Position your mouse to the empty field where you want your new (changed) table to start from – you can select the starting point of this table (A1) or click somewhere below. 
Right-click on the table and select Copy. The table’s color should change, signaling you that you have selected its parts. You can also use the Shift and arrow keys to select the cells with your keyboard. Select the entire table – just left-click, hold, and drag your mouse cursor across the entire table. Here’s the fastest way that you can do it. This process is called transposing, and it only takes a few clicks. This has been applied to the entire table. As you can see, we have A1, B1, C1, D1 in the place where we previously had A1, A2, A3, and A4, and vice versa.
0 kommentar(er)
