Chapter -6 Full M Code Power Query - Lists

Full M Code - Power Query Chapter 1- List #mcode #vikominstitute #excel 00:00 Introduction 00:47 How to Start Power Query 01:55 What is Lists in power query and Type of Lists 05:50 Records in Lists 08:35 How you can enter comments in M code 08:43 Lookups in Lists 13:49 List.Combine in power query 15:40 List.Zip in power query 17:48 List.InsertRange in power query 19:24 List.Distinct in power query Notes to the video List  Anything appearing in {} {1,2,3,4} {1..5} {{1,2,},{3,4},{5,6}} {[Name = “Vikal”],[Rollno = 3]} Lookup {1,2,3,4}{2} {{1,2},{3,4},{5,6}}{0}{1} {[Name = “Vikal”],[Rollno = 3]} [Name] Functions 1. List.Combine 2. List.Zip 3. List.Insert 4. List.Distinct Important Links Our You Tube channel 👍👍 https://www.youtube.com/c/VIKOMINSTIT... Our LinkedIn channel 👍👍   / excel-tricks-vikal-jain-8a011087   Instagram link 👍👍   / tricksexcel   Telegram link 👍👍 t.me/exceltricks1 Excel group links 👍👍   / tricksexcel   Twitter link 👍👍   / vikal10000   Wanna Paid courses 👍👍 Contact whatsapp +91-9213331108 or email info@vikominstitute.com