www.specialskills.in
Home
About
MICROSOFT
MICROSOFT Events and Training
Microsoft excel training
Services
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
Caution
Contact
More
Grapho Therapy
Forum
Articles
www.specialskills.in
Home
About
MICROSOFT
MICROSOFT Events and Training
Microsoft excel training
Services
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
Caution
Contact
More
Grapho Therapy
Forum
Articles
__
Services Segregated1
Services1
Services2
Services3
Services4
Services5
Services6
Services7
Services8
Services9
Services10
Services11
Services12
Services13
Services14
Services Segregated2
Services15
Services16
Services17
Services18
Services19
Services20
Services21
Services22
Services23
Services24
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