Excel enables you to analyze almost everything our information society has to offer. Unfortunately, data is often presented in a way that does not quite fit into the structure of your own table or sheet. In this Special Topic we will show you how to copy source data presented in rows in a way that allows you to rearrange it in columns and vice versa.

Published on: 13.12.2011

Excel 2016

Converting Rows to Columns  
It is possible to copy information from other Windows programs and paste them into an Excel table. Unfortunately, these copied information are usually organized in rows. This video will show you how to convert rows into columns and vice versa. (5 Min.)



Excel 2013

Converting Rows to Columns  
It is possible to copy information from other Windows programs and paste them into an Excel table. Unfortunately, these copied information are usually organized in rows. This video will show you how to convert rows into columns and vice versa. (5 Min.)



Excel 2010

Converting Rows to Columns  
It is possible to copy information from other Windows programs and paste them into an Excel table. Unfortunately, these copied information are usually organized in rows. This video will show you how to convert rows into columns and vice versa. (5 Min.)



Excel 2007

Converting Rows to Columns  
It is possible to copy information from other Windows programs and paste them into an Excel table. Unfortunately, these copied information are usually organized in rows. This video will show you how to convert rows into columns and vice versa. (3 Min.)