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.

Turn column into row excel