Skip to main content

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:

AB
1LANGUAGEDATABASE
2PHPMYSQL
3JAVASQLSERVER
4DOTNETMSACCESS

and You want to interchange rows and column data or transponsing the data like this:

ABCD
1LANGUAGEPHPJAVADOTNET
2DATABASEMYSQLSQLSERVERMSACCESS

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

Popular posts from this blog

How to apply for a new ration card and what are the documents required?

List of documents required for new ration card application in Kerala and how to apply


Application for a new ration card should be addressed to Taluk Supply Officer (TSO) / City Rationing Officer (CRO) of applicant's residing area.

Primary document required are Residence certificate, Income certificate and incase the applicant's name is in another ration card then he/she should submit the reduction certificate ontained from previous TSO / CRO as proof for removing his/her name from old Ration card.

You can get the new application from your currently residing Taluk Supply Office.

Payback Points - How to redeem - How to merge multiple payback accounts - Block Payback card - Payback customer care

Joomla and Forum Integration - Integrating Forums to Joomla

Joomla is one of the most popular CMS opensource packages. It is very easier to develop website's using Joomla. You just need to download Joomla package from Joomla's Official website www.joomla.org  and install it on your domain and later adding customizations to templates and feature and Your website is ready :). Now a days most websites provides a forum section for it users for discussing various article topics, gathering opinions etc.



Following are some best know forum opensource packages which can be integrated with Joomla and create a new forum experience for users


Urgent Openings for PHP trainees, Andriod / IOS developers and PHP developers in Kochi Trivandrum Calicut and Bangalore. Please Send Your updated resumes to recruit.vo@gmail.com   Read more »
Member
Search This Blog