How to Transpose - Rotate Row and Column in Excel - Tamil

[@murugansubbiah1784]

Super bro👌thnx a lot🙏

[@anandhibalamurugan112]

Excellent bro

[@vallirajraj2665]

Nice teaching..👌👌

[@sureshrajan3152]

really great

[@tharunkumar1958]

Just now learnt the Transpose formula..Thank you so much for your detailed explanation of Transpose feature..

[@malathig3439]

Thanks sir now it's useful for the targets as per brandwise and accountwise

[@MohanKumar-in5bi]

Thank you sir

[@sivakumarcp6705]

The way you explaining the concepts are awesome. Well keep it up. God bless you

[@Prabasmsoffice]

Thanks sir for providing a positive comment.

[@nivethav6766]

Nice teaching, I learned lot of excel formulas and tricks from your channel. Thank you for good teaching. Is transpose works in 2016?

[@Prabasmsoffice]

It works.

[@1gopalakrishnarao]

Excellent. Well explained. Thanks .Some more useful tips/tricks/ eagerly waiting. Very informative & very useful.

[@Prabasmsoffice]

+Gopala Krishna Thank you sir.

[@kumarsubramanian7086]

excellent explanation, even others fail to explain the vulnerable point, you narrated in the nice manner.

[@kumarsubramanian7086]

I will sure,thanks

[@Prabasmsoffice]

Appreciate your interest.

[@kumarsubramanian7086]

@@Prabasmsoffice My age is 57 plus,sheer interest calls the shot.

[@str2290]

Excel la " Transpos " erukunu enaku eppatha theriyum brother. Thank you so much for learning new lesson. Keep it up . thank you

[@Prabasmsoffice]

+kuttimma sankar Keep learning brother.

[@Janushika2021]

Super sir..

[@sachinsathish7484]

Tq very much

[@shenbaganathann9901]

Good sir nice teach

[@Prabasmsoffice]

+Shenbaganathan N Happy learning

[@prabhakaran4745]

Super sir

[@thangarajkeyboard]

Tq Sir..

[@Prabasmsoffice]

Keep watching and learning.

[@jayabalan2304]

Accounting based daybook debit credit entered automatically posted general ledger head wise

[@muthupandimuniyandi1439]

benefit sir

[@sandysanthosh4288]

Bro ipo oru customer ku multiple amount vertical data la irukuratha herizonder la varavaika mudiuma bro

[@Prabasmsoffice]

Yes, you can Transpose it.

[@youjahan1]

Tq sir

[@Prabasmsoffice]

+jahan badusha Keep learning

[@PrabhuPrabhu-po1iq]

Sir iam working on Telicom OME Operation . Now WhatsApp &Excel combating panalama

[@ranjithrash5329]

I learned second method now only. With using transpose formula

[@Prabasmsoffice]

Keep learning.

[@srajendran2328]

Coral draw prient செய்து அதே form யைExcelலில் மாற்ற முடியுமா மாதிரி ஒன்று மாற்றி காட்டவும்

[@sanjaikumar2510]

👍

[@eashwarsuriya2087]

Bro share a way to consolidate multiple excels in a folder

[@Prabasmsoffice]

kzbin.info/www/bejne/h5u9gphjnLCiqMk

[@Ridetoright111]

Hi praba.. எனக்கு Date format'la ஒரு சந்தேகம் இருக்கு.. சில நேரங்களில் date வந்து 12/22/2017 இந்த மாதிரி formats la large number of data கொடுத்திருக்கும் போது இதை ctrl+1 short cut கொடுத்து date format கொடுத்தாலும் 'அப்படி இல்லாமல் Customs'la போய்'ட்டு dd/mm/yyyy 'னு கொடுத்தாலும் மாறவில்லை இதற்கு என்ன முறையில் செய்யலாம்.. ஒரு video பதிவு போடுங்க..

[@Prabasmsoffice]

+sadha sivam Simple SadhaSivam. I have already created a video for this kind of Problem. Watch the below linked video without skipping it. kzbin.info/www/bejne/pKjEiZ1qfa9podU Do not skip any part of the video, Watch it completely.

[@Ridetoright111]

Thanks praba.. but In my previous comment I have mentioned wrong format like 22/12/2017 instead of 12/22/2017.. Actually I would receive large of data like this format only Mm/DD/yyyy.. And I have tried to change by using format options but nothing was helpful and the data remain the same..

[@Prabasmsoffice]

@@Ridetoright111 try to use text to column option to convert your wrong date to perfect format.

[@Ridetoright111]

@@Prabasmsoffice மிக்க நன்றி... நான் இன்று முயற்சி செய்து பார்க்கிறேன்...

[@venkatasubramanian5721]

Sir petrol fuel monthly document iruku sir athula 713561705473 Intha number maathiri 103 number irukum sir eapdium 800 thadavaku mela petrol potrupanga ipa intha numbera uniquea vachu source data va oru sheet la eaduthu pota oru 30 branch sheet athe work book la ulla antha antha number la date cost utkarura mathiri panalama sir help panunga sir

[@Prabasmsoffice]

Need more clarity about your source files and your expectation. A small discussion with sample files will be helpful.

[@nanthutamil47]

Thanks ...