Bhavya Gupta

Split Multiple Columns by Delimiter and Merge them in Power Query (2 Methods)

Add Dynamic Total By Column Custom Column in Power Query

Advanced Pivot and Utility of Index Column in Power Query (2 Methods)

Web Scraping Images using Power Query in Excel | 2 New Functions in Power Query

Data Transformation to create Comma Separated List in Power Query (Dynamically)

Extract Value Type as Text using Table.Schema Function in Power Query

How to Fetch Financial Data of a Stock in Excel from Screener in Simple Steps

Get Data From Picture in Excel (Desktop)

Append Multiple Columns/Text/Dynamic Arrays in Excel with UDFs in VBA

Remove Extra Spaces and Commas - TRIM in Power Query

How to Install Selenium Basic, Chrome Driver and Activate Selenium Type Library in Excel VBA

𝐃𝐲𝐧𝐚𝐦𝐢𝐜 𝐂𝐨𝐫𝐫𝐞𝐥𝐚𝐭𝐢𝐨𝐧 𝐌𝐚𝐭𝐫𝐢𝐱 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 𝐮𝐬𝐢𝐧𝐠 𝐌𝐀𝐊𝐄𝐀𝐑𝐑𝐀𝐘 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧

Dynamically Change Data Type of Multiple Columns using Power Query

Dynamically Split String of Characters into Equal Chunks using Excel Functions

Lookup Nth Value using Excel Functions | Exploring Special Properties of TAKE Function

Distinct Columns (as per Values) in Power Query

Format DateTime in Power Query as per Custom Format

Power Query Solution to Dynamic Split Challenge by Wyn Hopkins

Dynamic Cross Tabulated Report and trick to insert Tick Mark Font in Excel

Get Data From Picture in Excel (Desktop)

2 Excel Formulas to Separate or Split Text and Numbers in Excel | Advanced Excel | Full Explanation

Split Full Names in to separate columns with Variable Middle Names – Dynamic Power Query Solution

Multi-Column Stacked data into a Table – Power Query

Solutions to Power Query Challenge – Find First 90 | Invoke Custom Function in Power Query

3 Different Methods to Generate List of all Dates between Start Date and End Date in Power Query

Year To Date (YTD) Running Total using SCAN Function in Excel

Reverse Columns in Power Query

Running Average in Excel using Dynamic Array Formulas | SCAN, SEQUENCE & TAKE

Creating Pascal Triangle Matrix Using COMBIN Function in Excel | By Juliano Santos

Slanted Text and Border in Excel (Diagonally Aligned)

Insert Superscripts & Subscripts in Excel (With Keyboard Shortcuts)

[Resolved] Microsoft has blocked Macros from Running (Excel VBA)

Dynamically Expand Multiple Nested Tables Using Recursion & Extract Data from XML using Power Query

GroupKind.Local in Power Query | Solution to Count Stints Challenge by

SORT Numbers and Text Mixed as per correct Numerical Order in Power Query

Repeat each Item in the List given Variable number of Times

Formulas (2 Approaches) Solution to Dynamic Split Challenge by Wyn Hopkins

Dummy Variable Imputation in Power Query

Bulk Replacements (Replace Multiple Values in a Table at once) in Power Query

2 ways to Dynamically create Comma Separated List using Excel Formulas

Inverted Triangle Pattern in Power Query using M Functions

Get All Possible Pair Combinations from Two Lists in Power Query using M Language

Move Up Values when Null/Consolidate Rows Keeping Nulls at Last in Power Query

Shift Values to Left in Power Query Dynamically

Calculate Average ignoring Zeros or Blank cells - Two Formulas

Conditional Running Total and Count Using Power Query | Incredible Solution by

Searchable Drop-Down List in Excel with No Blanks and No Duplicates | Without VBA or Formulas

Lower Case Roman Numbers like i, ii, iii, etc. in Excel

Copy Data in a Worksheet to all other Sheets in the Workbook (without VBA Macro)

Generate QR Code in Excel using the new IMAGE Function