Anyone who has ever manually deposited large amounts of data will notice that this is no fun. It is not uncommon that one does not like the layout of the table. So you want to transpose in Excel and rotate the table to change from a vertical to a horizontal alignment or vice versa. Do you want to do this by hand? No! Fortunately, there is an easy way to rotate a table in Excel. We don’t want to deprive you of this one.
Simply copy and paste to transpose a Excel table:
There are no big steps necessary to be able to transpose in Excel. Just copy your complete table. The only important thing is that you cannot paste it in the same place, unless the number of columns and rows is identical. If this is not the case, save the table briefly in a different place and then paste it again in the desired position.
- Copy the data range you want to transpose
- Now right click on the line where you want to insert the data
- Select “Paste content” and this icon:
- The data is now copied from columns to rows or vice versa (depending on the original state)
With just a few clicks you can save a lot of effort in Microsoft Excel if you know where the function is hidden. We hope that we could help you with this article and we have many more useful topics for you! Have a look at our other Microsoft Excel tutorials!
Links with * are affiliate links. By purchasing via this link we receive a part of the purchase price as commission without any additional costs for you. This helps us to expand the offers available here for you! Thank you!