Bhavya Gupta

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

List of Values that Appear in All Columns in Power Query

Build Scalable Depreciation (WDV) Schedule in Excel with Dynamic Arrays and Mathematical Equations

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

Select Columns that starts with a given Prefix in Power Query Dynamically

Pivot Data Across Multiple Columns - 2 Step Dynamic Power Query Solution

Add Dynamic Total By Row Custom Column in Power Query

Max, Min, Maxifs & Minifs Functions in Excel

Reverse Columns in Power Query

Case Sensitive Unique Values in Excel

Remove all special characters from text at once (without Recursion)

Select Multiple Items from a List based on Index Positions in Power Query

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

Filter Table based on Multiple Values in a List in Power Query

New PIVOTBY Function in Excel

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

Overview of Functions in Excel | How to Find & Insert Functions

Create Dynamic Dependent Dropdown Lists in Multiple Rows in Excel

Copy Data in Multiple Cells to a Single Cell

Fill Right in Power Query (Just like we do Fill Down!)

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

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

Multi-Column Stacked data into a Table – Power Query

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

Power Query Solution to Dynamic Split Challenge by Wyn Hopkins

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

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

Remove all Numbers from String

Shift Values to Left in Power Query Dynamically

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