Skip to main content

How to Change Data from Rows to Columns in Excel

Most of the times you have to rebuild the Excel worksheet so that the rows are converted into columns and columns are converted into rows. If you copy and paste the data to rebuild the Excel table manually, then it will consume more time. In case you have a large data range, then it is impossible to do this procedure manually. Don’t worry; MS Excel has that feature which will do this procedure automatically. So, here’s how to change data from rows to columns in Excel.

Steps to Change Data from Rows to Columns in Excel

•    Select the data range which you want to change.

•    It can be any columns and rows.

•    Choose the data range by pressing on it.

•    Pull the mouse cursor.

•    Start copying the table by clicking on the Control and C keys together.

•    Additionally, you need to right-click on it.

•    After that, choose the Copy option.

•    You don’t have to use the Cut option or Control and X keys in case you wish to change the data.

•    Choose the empty spot on the Excel worksheet where you wish to paste the changed table.

•    Go to the empty Excel worksheet.

•    Start pasting the table on that worksheet.

•    When you paste new data above the old data, then the old data gets removed.

•    You need to right-click on the given space.

•    Move the mouse cursor above the “Paste Special” option.

•    Select the Transpose option.

•    The symbol starts showing the rows and columns on the screen.

•    The changing table starts showing in the given space.

•    You have to remove the old table from the Excel worksheet.

Steps to Change Data from Rows to Columns on Excel Online

•    Choose the data range which you wish to change.

•    You have to right-click on the chosen data range.

•    Choose the Copy option.

•    Select the empty spot provided on the Excel worksheet.

•    Choose the Paste symbol given on the Home option.

•    Choose the Paste transpose option.

•    This procedure will change data from rows to the column on Excel online.

How Do You Transpose a Table in Excel?

As the Excel features do not work properly with these tables, you have to change it to the data range. Here are the steps listed below to do this procedure:

•    Press on the Excel table.

•    You will get the “Table tools” over the Design option located on the upper side of the Excel worksheet.

•    Press on the Design option.

•    In case you are a Mac user, then choose the Table option.

•    Choose the Convert to Range option located in the Tools column.

•    Additionally, you can right-click on the Excel table.

•    Click on the Table option.

•    After that, choose the Convert to Range option.

Davis Johnson is a self-professed security expert; she has been making the people aware of the security threats. Her passion is to write about Cyber security, cryptography, malware, social engineering, internet and new media. She writes for Norton security products at



Popular posts from this blog

What Is Digital Marketing?

 What Is Digital Marketing? Digital marketing is that the use of the social media, Internet, search engines, mobile devices, and other channels to succeed in consumers. Some consider digital marketing to be entirely new which needs a replacement way of understanding that how customers behave and new ways of approaching the purchasers compared to the normal marketing. Digital Marketing Channels 1. Website Marketing 2. Pay-Per-Click (PPC) Advertising 3.Content Marketing 4.Email Marketing 5.Social Media Marketing 6.Affiliate Marketing 7.Video Marketing 8.SMS Messaging Digital Marketing As A course and Career The Digital Marketing course will transform you into a complete digital marketer with expertise in the top eight digital marketing domains — search engine optimization, social media, pay-per-click, conversion optimization, digital analytics, content, mobile, and email marketing. Fast-track your career in digital marketing today with practical training you can appl

Why Science Labs are Important for Students in School?

Science is a subject which allows students to explore and discover new theories. From a small atom to large universe everything is conceptualize with help of science education. But only theoretical knowledge is not sufficient. Practical knowledge is important to increase engagement and knowledge. Science lab is a place for student which functions to magnify deep understanding of theoretical concepts taught in classrooms. By this effective teaching method, students can gain numerous benefits. Ideal Education Point (New Choudhary public school) believes that ‘Child learn in class but understand in laboratories. Laboratories provide a great experience and high degree of knowledge in developing necessary skills for study and research. Science is a little difficult subject than any other therefore it is must for any school to have a science lab. Know the importance of science labs - • Understand difficult aspects One cannot just read the hefty science books and understand all the meaning

QAQC stands for Quality Assurance and Quality Control in management for production of goods and services.

 QAQC stands for Quality Assurance and Quality Control in management for production of goods and services. Quality Assurance is provided by a part of management system which gives confidence to the customer that his product requirements & legal requirements will be fulfilled. Quality Control is provided by a part of management system which ensures that the product meets all of customer requirements and legal requirements. The students are trained in International Standard for Quality for establishing, implementing and maintaining Quality Management System to meet both Quality Control and Quality Assurance requirements. They are trained to act as QAQC Engineer at work. TWG INTERNATIONAL Providing Trainings for all course related to Quality. The training is imparted by Super Specialist trainer with 40+ years’ experience. The subject is taught from basic level so that students can understand the subject with ease and without apprehension/ fears. There is major trend in