ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Muhammad Tariq , Data Entry Specialist , Rises Foundation International
تاريخ النشر: 2017/09/23
Bashar Alkhudairy
من قبل 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
من قبل 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
من قبل Simona Rubino , Corporate Governance Senior Research Associate , GLASS LEWIS

Copy rows data and use transponse feature

Janith Olagama
من قبل 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

 

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟