www.specialskills.in
Home
ABOUT
Hall of fame
data management
Why Learn data management in MS Excel?
data management programs
VBA Solutions
data Management Refund Policy
Disclaimer
Caution
Contact
More
Grapho Therapy
Forum
Articles
Lyrics
www.specialskills.in
Home
ABOUT
Hall of fame
data management
Why Learn data management in MS Excel?
data management programs
VBA Solutions
data Management Refund Policy
Disclaimer
Caution
Contact
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
Dwarka, New Delhi, Delhi, India
(110075)