Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Which formula of MS Excel is used for convert rows data into column data?

user-image
Question ajoutée par Muhammad Tariq , Data Entry Specialist , Rises Foundation International
Date de publication: 2017/09/23
Bashar Alkhudairy
par Bashar Alkhudairy , Specialist Computer Engineer , Kuwait University

There is an option in Excel to transpose the data (converting rows to columns and vice-versa).

One way to achieve this is to select your data , copy them and then paste special (by right click on the area where you want to paste the data) and check the option transpose and apply it.

This can be achieved through other means as well , but thats a simple way to do it . 

 

 

Zahir  Malpekar
par Zahir Malpekar , Senior Business intelligence consultant , Xilinx India

Use the tranpose feature of excel. It helps to convert rows data into column data and vice versa.

Simona Rubino
par Simona Rubino , Corporate Governance Senior Research Associate , GLASS LEWIS

Copy rows data and use transponse feature

Janith Olagama
par Janith Olagama , Finance Analyst , Deyaar Development PJSC

Its, Transpose, First copy the data in the column (or in the row) and click on a cell and right click, then select paste special in the pop-up window there should be an option to click transpose.

This works, either way, column data can be pasted as row data or row data can be pasted as column data.

Keyboard shortcut - alt -> e -> s -> e

 

More Questions Like This