How to interchange the rows and columns in a Open Office spreadsheet or Calc document - Transposing data in a spreadsheet
How to interchange the rows and columns in a Open Office spreadsheet document - Transposing data in a spreadsheet
How to interchange the rows and columns in a Open Office spreadsheet document
Suppose you have spreadsheet data like this:
and You want to interchange rows and column data or transponsing the data like this:
Transposing data in a spreadsheet
For this ...What you have to do is copy the content from the first spread sheet and then open the next spread sheet
then click on the "Edit" option and click one the "Paste Special" , then an option box will appear, in that "tick" on the "Transpose" option and click "Okay"
Now your Open Office Spreadsheet data is transposed :)
Possible Error
if you are getting an error like the one given below:
"There is not enough space on the sheet to insert here"
this means there is not enough rows or columns in the new spreadsheet to write the copied data. So before writing to a new spreadsheet please make sure there is enough space.
from the above example:
first table (before transposing) has 2 columns and 4 rows of data
and the transposed table has 4 columns and 2 rows.
so before pasting the contents of first table to generate the transpose, make sure that the new spread sheet document has atleast 4 coulmns and 2 rows.
this is very simple example, just think about data that has more rows and columns :)
With current releases of OpenOffice, calc will not handle more than 256 columns. If you copy a range with more than 256 rows, you can't paste+transpose in Calc.
How to interchange the rows and columns in a Open Office spreadsheet document
Suppose you have spreadsheet data like this:
| A | B | |
| 1 | LANGUAGE | DATABASE |
| 2 | PHP | MYSQL |
| 3 | JAVA | SQLSERVER |
| 4 | DOTNET | MSACCESS |
and You want to interchange rows and column data or transponsing the data like this:
| A | B | C | D | |
| 1 | LANGUAGE | PHP | JAVA | DOTNET |
| 2 | DATABASE | MYSQL | SQLSERVER | MSACCESS |
Transposing data in a spreadsheet
For this ...What you have to do is copy the content from the first spread sheet and then open the next spread sheet
then click on the "Edit" option and click one the "Paste Special" , then an option box will appear, in that "tick" on the "Transpose" option and click "Okay"
Now your Open Office Spreadsheet data is transposed :)
Possible Error
if you are getting an error like the one given below:
"There is not enough space on the sheet to insert here"
this means there is not enough rows or columns in the new spreadsheet to write the copied data. So before writing to a new spreadsheet please make sure there is enough space.
from the above example:
first table (before transposing) has 2 columns and 4 rows of data
and the transposed table has 4 columns and 2 rows.
so before pasting the contents of first table to generate the transpose, make sure that the new spread sheet document has atleast 4 coulmns and 2 rows.
this is very simple example, just think about data that has more rows and columns :)
With current releases of OpenOffice, calc will not handle more than 256 columns. If you copy a range with more than 256 rows, you can't paste+transpose in Calc.
Comments
Post a Comment