www.specialskills.in
Home
Recognitions AND CERTIFICATES
MICROSOFT
is learning ms excel important?
MS excel Courses
MS Excel Refund Policy
Disclaimer
Caution
Contact
Services
Tech solutions
Business solutions
Music/Hobby Solutions
Online Trainings
Video Marketing
Social Media Marketing
Fashion/Graphic Solutions
Services Content Pages
Purchase flow and Refund Policy
Disclaimer
Contact
Caution
More
Grapho Therapy
Forum
Articles
Lyrics
www.specialskills.in
Home
Recognitions AND CERTIFICATES
MICROSOFT
is learning ms excel important?
MS excel Courses
MS Excel Refund Policy
Disclaimer
Caution
Contact
Services
Tech solutions
Business solutions
Music/Hobby Solutions
Online Trainings
Video Marketing
Social Media Marketing
Fashion/Graphic Solutions
Services Content Pages
Purchase flow and Refund Policy
Disclaimer
Contact
Caution
More
Grapho Therapy
Forum
Articles
Lyrics
Home
Forum
How can you transpose data given in a specified column in worksheet 1 in MS Excel into a specified row in worksheet 2?
How can you transpose data given in a specified column in worksheet 1 in MS Excel into a specified row in worksheet 2?
Rajesh Pathak
Here is the solution:
Copy the worksheet 1 data, which needs to be transposed.
Go to worksheet 2
Keep the cursor in the cell of that row where you want data to be transposed.
Open paste special using
Alt E S
Select ‘Transpose’ option
Hit enter
Data will be pasted horizontally.
Homepage
MS EXCEL TRAINING
{"follow":"Follow","edit":"Edit","reply":"Comments","suggestedTopics":"Suggested Topics"}
+91-9971911018
-
Whats App
contact@specialskills.in