Combine Data from Folder Without Excel Tables | Get a List of File names from a Folder in Excel

Рет қаралды 13,919

3 жыл бұрын

Combine Data from Folder Without Excel Tables | Get a List of File names from a Folder in Excel | Combine Multiple Excel Files into One using Power Query
Excel Power Query Playlist Link- • Excel Power Query
Download the Assignment Master Practice Folder here (All Playlist Example at one place) drive.google.com/drive/folder...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#powerquery #powerqueryappend#innozant #getandtransformexcel

Пікірлер: 78

@muhammadhuzaifa4521 Жыл бұрын

Mjhy aisy video ki talash thi Thanks Respected Sir

@Innozant Жыл бұрын

Thanks dear .Keep learning

@muhammadhuzaifa4521 Жыл бұрын

Yes Sir

@rakeshmlearningentertainme6099 2 жыл бұрын

NICE ALL VIDEO SERIAL VISE I HAVE WATHCH THANKS LOTS SIR

@jayantabhattacharyya628 3 жыл бұрын

Dear Sir Again superb tutorial. Every power query tutorial is very informative and I am learning from it. Thanks Sir for giving Power Query topmost priority. Thanks & Regards Jayanta Bhattacharyya

@Innozant 3 жыл бұрын

Thanks Jayanta...Hope you like and learn from there..Gn

@TheSuvankarKundu 3 жыл бұрын

One of the most informative channel nd all ur vds r sooo much valuable

@Innozant 3 жыл бұрын

Thanks Suvankar Ji .Happy learning dear

@NilayMukhopadhyay 3 жыл бұрын

As I told you earlier. You are the best. This kind of professional information you're giving us for free also in simple language. Hats off 👍

@Innozant 3 жыл бұрын

Thanks Nilay... Really means a lot to me🙏❤️Never stop learning..

@NilayMukhopadhyay 3 жыл бұрын

Please upload a video on How to deal with different column names & same Column names in different positions.

@itsofficialsaini 2 жыл бұрын

Excellent sir how easily you clearify such a important topic of power query is brilliant 🙏

@Innozant 2 жыл бұрын

Thanks Pawan❤️❤️

@pramodbhavsar4488 3 жыл бұрын

Very nice information powerquery Append different extention files good example of Append file thank you sir

@Innozant 3 жыл бұрын

Thanks Pramod ji..Have a great day..Happy learning

@sandeepaswal8944 3 жыл бұрын

Excellent, quality training. Sir Videos like these are priceless

@Innozant 3 жыл бұрын

Thanks Sandeep Ji👍❤️

@sandeepaswal8944 3 жыл бұрын

@@Innozant Sir aapnai 9.12min sai aagai wali video mai aap Close & Load To.. kartai ho usmai mera PivotTable Report nahi aara hai.. Jaab ki mainai saab kuch sahi kiya hai. plz answer me

@acommonman155 Жыл бұрын

Thank you Guruji🙏 Dil Se ❤❤ You're THE BEST

@Innozant Жыл бұрын

Thanks Dear..Happy learning ❤️😊

@dpak_sharma Жыл бұрын

You are great sir you are doing a great job My wellwishes with you always 😊

@Innozant Жыл бұрын

Thanks Deepak Ji for your valuable appreciation dear..Keep Learning ❤️

@ajaysaroha2539 3 жыл бұрын

Wow,you are great sir we will take this opportunity in lockdown

@Innozant 3 жыл бұрын

Thanks Ajay .Good night..tc

@kishorpanara4191 3 жыл бұрын

Innozant best work for excel thanks sir

@Innozant 3 жыл бұрын

Thanks Koshor.Happy learning dear..Gn

@Altaf_Alam Жыл бұрын

❤ thank you sir ❤️

@satishojha6240 3 жыл бұрын

Good evening sir very informative video 🙏🙏🙏🙏🙏

@Innozant 3 жыл бұрын

Thanks Satish Ji Gn

@aqeelahmadengr3 3 жыл бұрын

Innozant, Good channel.

@Innozant 3 жыл бұрын

Thanks Aqeel

@eighttech 5 ай бұрын

Thanks ❤

@asmrindia Жыл бұрын

Hello Sir, Nice Video P.Q. me .xls ya Excel 97-2003 Version files ko directly import kse karenge, Bina Unhe Table Ya .xlsx file format Me convert kiye? Bataiyega Thanks

@sahilsreedharan 3 жыл бұрын

Innozant made Excel easy for life!!!

@Innozant 3 жыл бұрын

Thanks Sahil 🙏❤️

@mjaved701 3 жыл бұрын

Fantastic

@Innozant 3 жыл бұрын

Thanks Javed

@lavrijignesh8070 Жыл бұрын

Sir I have 1 question my PC install ms 2010 and me practice power quary but first update me sp1 after power quary install sp1 update to my old file is open proper

@delhibala9294 3 жыл бұрын

Sir me excel me kafi accha ho gya tha 17 din pehle sir typing ke jariye job lg gyi thi pr sir excel me future bnana h

@Innozant 3 жыл бұрын

Ohh.. practice kyu chor diyemmaise sab bhool jayenge aur dubara zeeo se start krna hoga..kya issue hai man kyu nhi lagta mmkab pata hainyahi career option h to

@dmeyufta3415 2 жыл бұрын

jatadhari g ----ky ahi bat hai

@Innozant 2 жыл бұрын

❤️❤️❤️❤️😀

@meditationmusic6482 3 жыл бұрын

So nice Sir ji...but CSV file mince kaya hota hai sir ji.

@Innozant 3 жыл бұрын

CSV-Comma seprated values

@RMKserve 2 жыл бұрын

Dear Sir I have noted you are transforming file with same extension like xlxs csv in single querry. Is is possible to transform files with different extensions in the same querry?

@Innozant 2 жыл бұрын

Yes it's is possible

@rewtikashyap4243 2 жыл бұрын

Hi Sir Firstly sir thanks for starting the series. In this video time 5:09 minute per all data compile but 734 errors coming in power query dialogue box. Pls help what is this bcz I m not understand and due to my data not compile correctly.

@aniketsharma7307 2 жыл бұрын

sir how can we sort our data in month chronological order in power query?

@Innozant 2 жыл бұрын

👍❤️

@user-hi6fu6jn2v 2 ай бұрын

Hello sir, I want to buy power query full course to learn from basic to advance please provide me purchase link.

@carpe_diem06 2 жыл бұрын

Sir how do i Extract and Change Data Type as i dnt have it in the Transform Tab....please help...i am using excel version 2016

@Innozant 2 жыл бұрын

When you open your data with power query ..it's already there in header

@vijaykundwal1041 Жыл бұрын

I am not able to get option of Pivot after clicking on Load to. Table and Only create Connection option only showing. Please help me in it.

@debdeepbhowmick7107 Жыл бұрын

sir, in this video we have two csv file ,after combine the csv files and removing the top rows(transforming) and loading the files in excel still I have 1st two unorganized rows of 2nd csv file. How can I individually transforming both files? sir plz help.

@Innozant Жыл бұрын

Find top row from transform and remove desired rows

@debdeepbhowmick7107 Жыл бұрын

@@Innozant I have done it from transform sample file. Thank you for the advice. 🙏

@harindersingh-sc2wb 9 ай бұрын

ek questions h sir - agar isme .xlsx file ko bina formula ke append kar skatey hai toh "Append Folder || Combine multiple excel file" iss video ke data ko direct combine karne per error kyu aa rha hai? jabki dono data ki files .xlsx ko combine kar rahe hai fir 1 me error kyu or dusre me kyu nahi?

@Abhisheksoni8738 6 ай бұрын

i have a multiple phone number and i want to extract only those number which have last 3 digit 345. using filter in excel

@delhibala9294 3 жыл бұрын

Sir me practice krne ka mn nhi krta aur tired bhi kafi ho jata hu sir ky kru plz help me?

@ravisrivastava6722 Жыл бұрын

2016 me conation ke baad pivort table ka option show nhi ho raha

@ravisrivastava6722 Жыл бұрын

Sir pdf upload ka option nhi show ho raha from file me

@funny15 3 жыл бұрын

Get data option not show 2007 office. How to process this option run 2007 office....?

@Innozant 3 жыл бұрын

Install power query plugins from Microsoft website

@funny15 3 жыл бұрын

@@Innozant install free or paid ......?

@Innozant 3 жыл бұрын

Its free dear..but recommend you to update latest version of ms office.. Inbuilt aata hai ab uske saath power query

@ravisrivastava6722 Жыл бұрын

Kaise aayega

@ravisrivastava6722 Жыл бұрын

Pdf option kaise aayega sir pls comment

@delhibala9294 3 жыл бұрын

How are you innozent sir I think you remember me?

@upasanapandey8770 3 жыл бұрын

For power bi

@Innozant 3 жыл бұрын

Upasana ji.After power query and power pivot..will start power bi

@Innozant 3 жыл бұрын

Yes dear

@SAJJADAHMAD-uy3hu 6 ай бұрын

jab first row ku header bana diya tu ussey pahley sourcename ku order se change kyun kiya. Direct first row ku header bana detey.

@Thoughtwithsurya 2 жыл бұрын

महोदय मैं एमएस ऑफिस का कौन सा सस्क्रिब्शन लू। मैं सरकारी कार्यालय में काम करता हूं मुझे एक्सेल में कुछ नया सीखना व करना पसंद है

@Innozant 2 жыл бұрын

Office 365 lijiye yadi subscription le rhe hain to..saare new formulas available hain usme

@pravinandher428 3 жыл бұрын

VBA LECTURE

@Innozant 3 жыл бұрын

Layenge

@pravinandher428 3 жыл бұрын

Thank You