Skip to main content


Welcome to Daily Updates

*** Happy Learning***
==>Daily Job Updates IT and Non IT

==>Every month Current Affairs

==>Every month Dividend, Bonus Issue and Stock Split information

==> JAVASCRIPT QUIZ

==>AADHAAR download, Date of birth,name and Address correction, PVC card and more links

==> MICROSOFT EXCEL TUTORIAL

How to convert vertical data to Horizontal in excel

 How to convert vertical data to Horizontal in excel 

Now in this, we can see how to convert the vertical data to Horizontal data in excel. For conversion follow the below steps

Step1: 

Let the file has data as below


Step2:

And copy the data and click on the required cell and then type Alt+E+S, You will see the screen as follows there enable the check box for Transpose




Step 3:
Hit on Enter. we can see the conversion of vertical data to Horizontal data in excel 


Finally you learned How to convert vertical data to Horizontal in excel . Any questions please comment 

Labels:

Comments

Post a Comment

Popular posts from this blog

JNTUK R16 percentage calculation

JNTUK R16 PERCENTAGE CALCULATION Here R16 batch students can calculate percentage according to obtained CGPA throughout the graduation. JNTUK introduced SGPA, CGPA in 2020 batch that is R16 REGULATION. Most of the companies ask percentage but students suffer how much percentage equal to obtained CGPA. for that here providing a wonderful platform for calculation of percentage by providing CGPA. ENETR CGPA BELOW BOX AND GET PERCENTAGE: ENTER CGPA    Percentage   For Lateral Entry students CGPA Calculator-  click here for Regular students CGPA Calculator -   click here Andhra Pradesh SI and Constable recruitment Notification 2022 Details - Click here for more details feel free to comment ...
Post a Comment
Read more

JNTUK Convocation VIII for 2018-19 and 2019-20 batch OD apply

JNTUK Convocation VIII for 2018-19 and 2019-20 batch, who have taken the PC in the period of 01/01/2019 to 31/12/2020 For more details Click here last Date to apply - 18-12-2021 Required Documents: 1. PC 2. CMM (For UG ) 3. SSC 4. Recent Photo  5. For PG courses - Sem wise mark sheets 6. Adhaar front and back scanned copy 7. Bank challan or Payment - Those made offline payment should submit hard copies of above documents at the university examination Fee - Rs.2000/- Process to apply: 1. Register with Hall ticket number and email Id(user name) - Click here 2. Login with user name(E-mail ID) and password - click here 3. Enter the details and next step will be payment  Note: Updation of payment status into complete status may take 2-3 days 4. Then need to attach the required documents 5. Next step is to check the details and everything and then click on check box by agreeing that there information was furnished by you is true. 6. There will be no Submit option that is only downlo...
Post a Comment
Read more

JNTUK R16 SGPA and CGPA calculator for Lateral entry b.tech

Lateral entry students those are joined directly engineering by completing polytechnic, they may or may not appeared for ECET for getting seat in engineering course. that is B.Tech students studied course in 4 years but lateral entry students studied course is 3 years, that one year spend in polytechnic course. Lateral entry students strong in Technically than regular students. for SGPA calculator -   click here NOTE: IF ANYONE WANT CALCULATE UPTO SOME SEMISTERS(LIKE UPTO 3-2) FOR PLACEMENTS CAN PROVIDE REMAINING SGPAS AND TOTAL CREDITS AS ZEROS(0) THEN WILL GET ACCURATE CGPA TILL THAT PARTICULAR SEMISTER. FOR LATERAL ENTRY SCHEME B.TECH CGPA IS... FIRST SEMISTER SGPA    total credits   SECOND SEMISTER SGPA    total credits   THIRD SEMISTER SGPA    total credits   FOURTH SEMISTER SGPA    total credits   FIFTH S...
1 comment
Read more