The months are now in columns, and the different amount types are on the column headers of the new table. Result: The contents of the table or rows are transposed to the new location. Selecting the data to be rotated with Excel Then right-click, select Paste Special, then Transpose, as shown in the image below.Or with the shortcut CTRL+A for a table.Ģ – Then copy the table to be rotated with CTRL+C or right-click and Copy. With the mouse or the arrows if it is a large area. In fact, here are the details of the three steps with screenshots to transpose the rows of the Excel table into columns.ġ – First of all, select the whole area to be rotated in the Excel sheet. Paste the rows to be rotated, with the special paste option: Transpose.Copy the rows with CTRL + C for example.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.Here are 3 simple steps to rotate rows into columns in Excel 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.

Convert rows to columns in excel