5
Select the cell where you want to paste, Go to Paste special , choose value in paste section and select Transpose in operation click on ok
From India, Bangalore
From India, Bangalore
Hi All, I am working with a HealthCare company in Delhi as Assistant Manager - HR, Kindly call me at 9560899988 for any job as doctor/Front Office Manager, Accounts etc. Regards Minakshi Sharma
From India, Delhi
From India, Delhi
HI
1) Select the row from E 17 to I 17.
SIVA
2) Type "=" & type "Transpose".
=TRANSPOSE'
3) open Bracket & select the row to be transpose & close bracket.
=transpose(E7:E11)'
4) Then Press "Shift +Ctrl +Enter".
Regards,
Ksukumar
From India, Jalandhar
1) Select the row from E 17 to I 17.
SIVA
2) Type "=" & type "Transpose".
=TRANSPOSE'
3) open Bracket & select the row to be transpose & close bracket.
=transpose(E7:E11)'
4) Then Press "Shift +Ctrl +Enter".
Regards,
Ksukumar
From India, Jalandhar
Dear Friend,
If you have that solution in forumal or Pasting Option, Becuase , some time the name can be shuffeled, that time the paste special option cannot be applicable in case if you do that it come wrong output
Jus Put Sum if Formmula for the each Row
=SUMIF($D$6:$D$13,E16,$E$6:$E$13)
Now automatically the exact amount will come, but one thing the same name cannot be repeated
From India, Madras
If you have that solution in forumal or Pasting Option, Becuase , some time the name can be shuffeled, that time the paste special option cannot be applicable in case if you do that it come wrong output
Jus Put Sum if Formmula for the each Row
=SUMIF($D$6:$D$13,E16,$E$6:$E$13)
Now automatically the exact amount will come, but one thing the same name cannot be repeated
From India, Madras
Normal V Lookup formula
or our friend says the same method Transpose method
1. First copy the Required Data
2. Go tp Paste Special option
3. below there have option Transpose
4. just Select and enter (now your requirement is over)
From India, Madras
or our friend says the same method Transpose method
1. First copy the Required Data
2. Go tp Paste Special option
3. below there have option Transpose
4. just Select and enter (now your requirement is over)
From India, Madras
Hi,
I have attached excel file. Check your file and if you want any more changes tell me.
Also You can post your queries in below mentioned forum, in this forum there are many people join.
Forms, Formats & Questionnaires
From United Kingdom
I have attached excel file. Check your file and if you want any more changes tell me.
Also You can post your queries in below mentioned forum, in this forum there are many people join.
Forms, Formats & Questionnaires
From United Kingdom
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
EXCEL FORMULA.xls