What is Transposing data? • Transposing data means moving the row data to a column and a column data to a row. • It is very useful for data analysis. • At times, we pull data from various files with different formats for analysis and report preparation. • In such circumstances, we may have to transpose some data from one file to the other as all files may not be in the required order.
Email: Support@skillfinlearning.com
Mobile: 9650010925
Using Paste special (1/3) • In this method, the data is transposed using Paste Special Transpose feature in Excel.
• We have a list of Companies with Revenues, Profits, and margins in a horizontal format. • We want to transpose this data in a vertical format.
• Here the transposed data is static. That means, it does not change with the change in the source data.
Email: Support@skillfinlearning.com
Mobile: 9650010925
Using Paste special (2/3) • • •
•
To transpose this data, select the data and Press Control + C to copy it. Then go to the cell where you want to paste this data and right click your mouse. You get a list of options. Select Paste Special.
Email: Support@skillfinlearning.com
Mobile: 9650010925
Once you select Paste Special, You get the following screen
Using Paste special (3/3) •
•
Select the option Values and Transpose.
Then Click OK
Email: Support@skillfinlearning.com
•
You get the following table.
• •
The data is pasted in a vertical table format. You can now format the data and proceed with the analysis required.
Mobile: 9650010925
Want to learn more?
Explore our “Data Analysts Skills Training” (DAST) course Go from beginner to an Expert in Data analytics Skills in Excel. Join this program to build your Excel analytical skill quickly through hands on project Skills you will master: ✔Data analytics functionalities in Excel ✔Data visualization through charts ✔Logical analysis driven decision-making ✔Data cleaning and improvisation methods ✔Pivot Table analysis ✔Professionally format datasheets ✔Excel tips and tricks using shortcuts ✔Excel skills for business purposes ✔Apply data analysis on real life datasets
Coaching includes: ✔Annual (1 year) Subscription ✔100+ Live Interactive Sessions ✔Unlimited Access to Video Content ✔Weekly Mentorship Assistance ✔Individual Assignments Evaluation ✔Access on Mobile and Tablet also ✔Certificate of Completion
For more details please visit Data Analyst Skills Training (DAST)
Email: Support@skillfinlearning.com
Mobile: 9650010925
Our Training approach ensures You Learn Effectively in Less Time
Email: Support@skillfinlearning.com
Mobile: 9650010925
THANK YOU Visit Skillfinlearning.com
Email: Support@skillfinlearning.com
Mobile: 9650010925