#1 Excel trick to earn Rs. 436 in just 1 hour (Merge Data) 🚀

[@learnwithlokeshlalwani]

FREE Live Masterclass. Register Now. 🔥🔥 event.webinarjam.com/register/13/m4851s2

[@Rohit-nv4cq]

Sir kaam kar lainge per muje client se baat karna nahi ati ki unko subse pahele or bich ma na kase baat kare pleace reply...🙏🙏🙏🙏

[@mjassal]

Sir, can I do this work on mobile phone??

[@chandraprakashmeghwal380]

Use laptop please

[@yogeshkumawat7274]

2007 me chal jaye ga kya

[@Dodo96-perfect]

Sir mai debt mai hu bs Roz ke 300 ra Roz mil jaye please Mera debt utr jayega please help me 🙏

[@IsaacTorres-es3te]

MAI BOHOT PARESHAN THA BUT AAPKI TIPS I WAJE SE MERI LIFE CHANGE HOGYIUI MAI BANKRUPT SE BACH GAYA AUR DAILY KA GHR BAITHE MAI 2 SE 3 HAKJAR KA MA LATA HUN learn with lokesh lalwani m THANK YOU SO MUCH DEAR

[@natural_happiness]

Many many thanks 🙏🙏🙏 dear sir 🙏... your good important subject... I'm daily watch your all Excel knowledge video... good ... I m follow you sir one year.... dear sir... are you very excellent ms Excel knowledge teacher....i proud of you sir....

[@laibasiddiqui9711]

I love your content. You say the exact words that needs to be said

[@austindean9274]

Your teaching method is far easier than others', making learning a breeze.

[@learnwithlokeshlalwani]

Glad to hear that!

[@officialh.rscientificfact8105]

bhaiya aap explain bahut acha karte ho but mein aapko suggest kahunga ki jo aap proof batate hai vo last me bataye to jada acha hota please 😊😊

[@Shawrav_Abdullah]

Hi . I am from Bangladesh. I really love your videos specially every single instructions. You are really genius.

[@learnwithlokeshlalwani]

Many many thanks

[@Amit.786-y5o]

Iam first visit to your chanel,your knowledge Sir mind-blowing.. Thanku for knowledge 🙏

[@learnwithlokeshlalwani]

Thanks and welcome

[@SajidKhan-un8vz]

Awesome trick sir , always keep awaiting for new videos ...

[@learnwithlokeshlalwani]

Keep watching

[@kamalHossen0583]

Real Mentor! Thanks from Bangladesh.

[@learnwithlokeshlalwani]

Most welcome!

[@sunilsandy5244]

Aap bahut acha kaam kr rahe ho❤❤❤

[@learnwithlokeshlalwani]

you so much for your comment.

[@satyal8907]

Hum ko Kadwa lage tho bi bahuth aacha Hai,it's eyes breaking motivational

[@sanjayg3316]

TRUSTED CHANNEL 👍👍👍👌

[@learnwithlokeshlalwani]

Thank you for your comment.

[@jiminlover1764]

Mujhe Excel m expert hona h sir achhe se 😊

[@learnwithlokeshlalwani]

Join my webinar. event.webinarjam.com/register/13/m4851s2

[@ajmohanty5791]

thank you so much sir u are the best teacher in my life and you are the biggest idol for me. mein apka chennel subscribe kia hoon apka har ek video dekhraha hoon like bhi karta hoon apka har video aur trick apply karn ke liye mein Microsoft 365 ka ek mahine ka subscription lia hoon aur excercise file download karke pracctice karraha hoon

[@learnwithlokeshlalwani]

I am truly humbled by your kind words! It means the world to me to have such dedicated and enthusiastic students like you. Your commitment to learning and applying what you've learned is truly commendable. Keep up the fantastic work, and I look forward to seeing your progress.

[@ajmohanty5791]

@@learnwithlokeshlalwani apka har ek trick video with excercise file mei apne laptop mein save karke ek ek folder 📁 banake rakha hoon aur din me 1 ya 2 ghante nikalke practice karraha hoon

[@mygamingshow2641]

sir please provide latest version of excel you are using because some features are unavailable like VSTACK and Analze Data etc. so that it is easy to practice excel same like you sir .

[@nehazahra5800]

Your video illustration is super different 👍

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@abdulusman7045]

Bahot badiya explanation sir...

[@Basicinfoansari9211]

I like you sir You 😎 awasome

[@funcityg]

aapki video ka wait rahega thanks you so much...

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@NasirKhan-z6l9d]

I like your teaching method because it is way better than others but I have a question the dates are not correct. love from Pakistan

[@hajarakk602]

Superb bhai ❤

[@neverstoplearning1747]

Thank You again for the amazing video. Please make video on taxes for freelancer.

[@learnwithlokeshlalwani]

Sure I will

[@extraabubakar2879]

@@learnwithlokeshlalwaniThanks Alot again for amazing video ❤ Please make video how to create fiver Gig 😢please

[@wasimahmed6918]

My dear Lokesh Sir, Your video is very helpful & inspiring, I am going to join you masterclass very soon, I faced problems while merging the data of several sheets because the VSTACK formula is not working properly, please some tips is required, I am working MS-Office professional plus 2013 (Wasim Ahmed from Pakistan) thanks

[@learnwithlokeshlalwani]

VSTACK is available in Excel in Microsoft 365 version 2208 (Build 15601) and later, not in older versions of Excel.

[@rasheed256]

Hi sir i am new in your channel and i am so appreciate from ur video

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@TradeWithAsiff]

Sir I’m agree with you love from pakistan❤

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@anuradhasingh3259]

Sir please create a video that how can we make a good attractive profile on freelancing platforms.

[@PMDISHA-p6b]

dear sir your all video help full for all freelancers

[@learnwithlokeshlalwani]

Glad to hear that

[@Rizwanpatanwala-zz2yz]

Respected Lokesh sir, please mention VSTACK is available in Excel in Microsoft 365 version 2208 and later, not in older versions of Excel.

[@Basicinfoansari9211]

Yes

[@sujat_9762]

Apka video bahat achcha lagta hai but pura details denga to or vhi achcha ho ta hai

[@Eagleworld652]

I am new subscriber 😊😊😊😊 your video very yousfull

[@learnwithlokeshlalwani]

Thank you so much for your comment and subscribing.

[@alimehmood7105]

Sir I am big fan of you....sir you're too much motivator..

[@learnwithlokeshlalwani]

Thank you so much

[@chandraprakashmeghwal380]

I am a hard worker too,so let’s try this

[@Biswa-hg8vk]

Mughe Excel nahi pata video dekhne ke bad mughe ye Kam karne ka man he...

[@MD.SHAFINALAM]

Some changes can be noticed in the case of "Order Date" and "Ship Date". Those data do not remain the same after doing this trick. In those cases, some values show instead of the dates. This is a problem for this type of trick I think. Do you have any solution for that?

[@ShahidAbbas-w7l]

kindly guide the excel version as i am trying to merge data but vstack formula is not showing on my excel which is excel 2010

[@sujalpandey-xc1do]

Sir I don't have a feature of VSTACK in my laptop so do you have any other option which I can use to combine these sheets

[@mayankmaurya2001]

Please sir make a playlist for data entry and step by make account on online platform?

[@ShahidAbbas-w7l]

LOKESH bhai i like your videos.

[@learnwithlokeshlalwani]

Thank you so much!

[@meetbollywoodeditz]

@learnwithlokeshlalwali there's an error with VSTACK formula which showing (#NAME! error) every time , what's the solution ...sir??

[@learnwithlokeshlalwani]

VSTACK is available in Excel in Microsoft 365 version 2208 (Build 15601) and later, not in older versions of Excel. Availability. Both VSTACK and HSTACK can be found within the Lookup & Reference category of the Excel Function Library. If they're not, then it means you don't have a current Microsoft 365 subscription.

[@balakrishna981]

Awesome video sir as always. Please make a video on how to get Microsoft certified on Excel..

[@learnwithlokeshlalwani]

Sure I will

[@clickclickbangtan]

2:10 video starts

[@roshanmazhar1955]

Applied thx a lot for this video plz provide link for power Bi tutotial

[@nothinghappened6007]

17 no comment and 891 no viewer. Love from Bangladesh. Note: When I went to preview I saw that the date format had changed. Which happened in your video as well. I have seen it and fixed it myself but many people don't understand these things. It would be nice to see a video showing what to do to fix it. I'm already a fan of you. Hope to be continued.

[@fact2fied]

Bro can you tell me how you fixed the date format...Plz

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@aishlayvlog]

Real motivation ❤

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@tanmaychoudhary9599]

Sir project kaise milenge us pr video bnaiye​@@learnwithlokeshlalwani

[@Saurav_singh005]

I had previously watched your videos but never started working on it and this is the regret i am carrying now..

[@learnwithlokeshlalwani]

I understand how that might feel. Regrets can be tough to bear, but it's never too late to pick things up again. Your interest in my videos means a lot.

[@rahulgraphicsmalda]

allah aap ko accha rakhe hamesa abad rakhe

[@yaminivadigineni3929]

Thank you so much Lokesh Sir! Your videos are inspiring and have helped me to start taking this seriously. One thing, after merging the data we are not able to format the data into a table. It does not support with the formula used. Any solution to that?

[@all.car.available7165]

Sir ye kaam submit kese karna hai ❤❤

[@lathamudaliyar5644]

Sir whenever you upload such videos, pls mention it will be applicable in which excel ie 2013, 2019 or 365

[@Motivationtamil10]

More clients so not easy to get order.. More competition

[@euphrasiagomes4271]

Excellent trick. I like this.

[@learnwithlokeshlalwani]

Thanks for liking

[@raidriar68]

Please update Excel Masterclass - Beginner to Advanced according to new update of integration python programming language in excel!!!!!!

[@m-7767]

Hello sir Can you explain how to create account with discription and how to create gig and how to get job.

[@Aziz-qb6mj]

sir Vstack ka formula nahi aa raha hai office 2016 mein

[@Earthtu]

Kya hum ek profile mei Alag alg *Gig* bana sakte hai Jaise - data excel merger, web developer, web data warp

[@learnwithlokeshlalwani]

Haan, aap ek profile mein alag-alag gigs bana sakte hain! Aapke skills ke hisab se alag services offer karke apni profile ko diverse aur appealing bana sakte hain. Isse aapko aur jyada opportunities mil sakti hain aur clients ko bhi aapki versatility dikhne lagegi.

[@creatormode77]

Sir asa kuch platform batayiye jo fiverr jese platform chod ke online work from home work kar excel ke upar karke earning kar sake

[@skillshub1648]

Many many thanks dear sir

[@HarshitDubey-z4u]

OFFICE 365 Main VSTACK ka formula show nhi ho raha mere main kya karu 2021 office 365 hai

[@debiprasaddutta2506]

Dear Sir, while MERGING the sheet, I faces an error (#NAME?, when I move my cursor on the error, it shows " The Formula Contains Unrecognize Text". I also give you the formula I used as per your video "=VSTACK(Andhra:Punjab!A2:J200)". kindly help me in the issue. So that I can do the rest. Warm Regards, Debi Prasad Dutta.

[@FireX-24]

Sir Please Help Me Order Date Aur Ship Date Sahi Se Dadikate Nhi Ker Paya

[@Hassantariq034]

Everything is great but there's only one minor thing missed, when the data is merged after using the formula, the dates are changed

[@fuzailharoon7689]

Array 1 is not selecting when I am clicking on Andhra sheet.

[@Hassantariq034]

which office version are you using?@@fuzailharoon7689

[@mohammedzubairuddin146]

But you can change in Home tab just change from General to Date format.

[@adityagarg5544]

Sir awesome video can u also make a video through which teenager can earn a small amount of money regularly

[@adityagarg5544]

Bur really your videos are awesome 👍🏿👍🏿

[@learnwithlokeshlalwani]

Thank you so much for your comments. Sure, will make a video in future.

[@samarkundu9497]

Ap excel ka konsa version use kar rahe ho ?

[@iaminsane7684]

sir maine bhi same formula use kiya tha lekin mera #NAME? dikha rha hai . PLZ help

[@ShazyMalik-u8b]

vstack not available in excel 2016 please give an alternate way.

[@sadikhuddar1705]

sir i am using excel 2021 but formula vstack is not there do we need to enable or something if you know please help me

[@SreekanthCiri]

SQL server se data ko leke power BI pe report & dashboard kaise banana hai. Pl explain.

[@NAGESH_789]

Mobile par paise kaise kamae iss par video banae please

[@kushrana1237]

Order date or ship date mistake 😞 ho ga raha ha

[@rajendrasharma-qu1uz]

Good evening sir!! Need bit help - VSTACK function not available in my excel. Even that can't add from browse option from Ads-ins dialog box. Please suggest 🙏

[@learnwithlokeshlalwani]

The VSTACK and HSTACK Functions in Excel are pretty new functions. These functions can be used by Microsoft 365 users.

[@priyankarathore14]

Aap khud consolidate se merge karke q ni dikhate h sab new version ni use krte h excel old version ho to kaise karenge ye bi bataya kariye

[@Respect_DNS]

#1st_viwe❤.

[@rajkiratkaur1449]

Hello Sir Thank you for uploading such videos, these are very helpful to us. However, I am not able to add a new sheet in the data u have provided. If someone has tried it kindly let me know.

[@Sukhendra_kewat]

This work we can using power query easily

[@ashishranjan7901]

Sir aap Consolidate Option Se kr sakta tha ye isse bhi jaildi Data option mein hota ha ye...❤

[@teamxproyt9494]

SIR VSTACK FORMULA LAG HE NHI RAHA EXCEL M MERA MICROSOFT 365 HAI

[@bhikhabhaipatel6209]

Dear Sir I try to practice this data on Microsoft office 365 but not openning file on its pl help

[@sumansoni3223]

good evening sir, i have window 11 in my dell laptop, and vstack ka formula meri suggestion list me show hi nhi ho rha h

[@pragatisawant1724]

how to download vstack library from if we do not have vstack function in excel 2016

[@HayyatVoice]

Sir mera formula apply nahi hu raha sir kindly guide kr den i am from Pakistan

[@Storiesto]

Hello sir, ye formula bahot useful to he pr mere computer me show nahi kr raha. work nahi kr raha ye. me kese update karu excel ko. please help me

[@Qadeer-s7k]

Sir standard and premium packages ka kia matlab hai

[@ArjunThapa-mu3si]

Sir ji kya apne ads mo nitize nhi kiye kya ek bhi ads nhi ata aapke videos pe

[@TKP-Creativity-ig8ny]

How can I download your spreadsheet to my lap

[@Krishna-nm5yr90]

How to create Fiverr account

[@amitx7128]

Ispr video banao pls

[@SurajKushwaha-s8o]

Yes sir please create a fiverr account

[@extraabubakar2879]

Hello sir please is per Fiver ki Gig banana bata da 😢

[@shreeanu9196]

Yes

[@arpanuc]

I will create your fiver acc.

[@sultantamboli4993]

Sir is work sheet me order date and ship date me number aur date dono show kar raha he

[@shivinnya8091]

I tried to create my account on Fiverr but I'm facing 2 problem. First it is compulsory to upload your project 's images and data. 2 . Payment currency is showing in dollars I tried to change in rupees but it's don't change

[@AbuzarWali-ni1jb]

vstack wala step samjh mein nahi aaya select kar raha hun lekin ho nahi raha hai

[@theriadid7566]

Please put video for Fiverr account registration for Excel work

[@aarushgautam-ci4zc]

SIR SHIFT PRESS KARKE SHEETS SELECT NAHI HO RAHI HAI PLEASE TELL OTHER SHORTCUT TO DO THIS

[@Basicinfoansari9211]

But ye wala formula mere Excel me show nhi kar rha hai

[@JUTT_Bros]

same

[@raghavsharma-k4c]

Which version support vstack formula?

[@kingyy._.52]

Sir please make a video on what are the resources we need for freelance 🥺 like laptop, phone etc 🙏🙏

[@learnwithlokeshlalwani]

Sure, will make a video in future.

[@kingyy._.52]

@@learnwithlokeshlalwani thank you so much sir means a lot 🙏🙏❤️❤️

[@org_anicmeme]

as content writter ...or data entry ,copy writer job nahi mil... rahi hai sir 😔

[@anshulsinghal8788]

We type in this formula in excel 19 still not getting the formula by pressing tab button, do we have any other option or we can edit by adding the formula in excel only so that we can apply this formula by not changing or downloading new excel versions.

[@sarastudio7410]

love from Bangladesh

[@Hassantariq034]

Suddenly my ms office 2021 stopped supporting vstack formula 😢

[@AnkitSrivastav443]

In my Excel VSTACK doesn't exist, what should I do now?

[@learnwithlokeshlalwani]

Which excel version you ate using. VSTACK is available in Excel in Microsoft 365 version 2208

[@rashmibhatia6855]

Sir can you show this on mobile 📱 how to do this work in mobile?