Skip to content
OmidBI Logo – Expert in Power Query, Excel, and Business Intelligence Solutions

OmidBI

  • By Difficulty
    • ⭐️ Beginner
    • ⭐️⭐️ Easy
    • ⭐️⭐️⭐️ Intermediate
    • ⭐️⭐️⭐️⭐️ Advanced
    • ⭐️⭐️⭐️⭐️⭐️Expert
    • ⭐️⭐️⭐️⭐️⭐️⭐️Complex
  • By Topic
    • Advanced Mathematics Problem
    • Aggregation & Summarization
    • Column Splitting
    • Column Transformation
    • Custom Grouping
    • Data Cleaning
    • Data Transformation
    • Date & Time Handling
    • Financial Problems
    • Indexing & Ranking
    • Merging & Joining
    • Missing Values
    • Pivot & Unpivot
    • Text Processing
  • By Creator
    • Omid Challenges
    • ExcelBI Excel Challenges
    • ExcelBI Power Query Challenges
    • Crispo Challenges
  • By Software
    • DAX Challenges
    • Excel Challenges
    • Excel VBA Challenges
    • Google Sheets Challenges
    • Office Script Challenges
    • Power Query Challenges
    • Python Challenges
    • R Challenges
    • SQL Challenges
  • Books
    • 96 Common Challenges in Power Query
Home » General Tags » Power Query » M Functions » M List Functions » List.Transform » Page 3

List.Transform

Applies a function to each element in a list in Power Query.

Minimum Sum Unique Pairs
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Minimum Sum Unique Pairs

Challenge No. 588: Find the unique pairs for which sum in minimum across the columns.
Solved using: R.

December 21, 2025July 11, 2025
Cross Product with Multiples
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Cross Product with Multiples

Challenge No. 584: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: R.

December 19, 2025July 11, 2025
Transpose table: As in one
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Transpose table: As in one

Challenge No. 268: Transpose the given table as show.
Solved using: R.

December 18, 2025July 14, 2025
Digit Sum in Fibonacci Sequence
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Digit Sum in Fibonacci Sequence

Challenge No. 580: Let’s code golf.
Solved using: Python.

December 17, 2025July 30, 2025
Top Three Column Products
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Top Three Column Products

Challenge No. 578: Find the top 3 max product from the combination of numbers from 3 columns (Number1, Number2, Number3).
Solved using: Python.

December 16, 2025July 30, 2025
Populate the addresses for Greek
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️ Beginner

Populate the addresses for Greek

Challenge No. 264: Populate the addresses for Greek alphabets appearing in the grid.
Solved using: Python in Excel.

December 14, 2025July 14, 2025
Transpose the given data from
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️ Intermediate

Transpose the given data from

Challenge No. 261: Transpose the given data from Problem Table into Result table as shown.
Solved using: Python in Excel.

December 11, 2025July 14, 2025
Sort Only Numeric Columns
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Sort Only Numeric Columns

Challenge No. 564: Sort the columns where only numbers will be sorted and non-numbers will not be sorted.
Solved using: R.

December 9, 2025July 30, 2025
Maximum Profit from Transactions
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Maximum Profit from Transactions

Challenge No. 561: For each row, you need to buy first and sell second.
Solved using: Python in Excel.

December 7, 2025July 30, 2025
Tap Code Cipher Generator
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Tap Code Cipher Generator

Challenge No. 548: Since long, I didn’t post a cipher challenge.
Solved using: Python in Excel.

December 1, 2025July 30, 2025

Posts pagination

Previous 1 2 3 4 … 24 Next
  • 96 Common Challenges in Power Query
  • Advanced Mathematics Problem
  • Aggregation & Summarization
  • Books
  • Column Splitting
  • Column Transformation
  • Crispo Challenges
  • Custom Aggregation & Summarization
  • Custom Grouping
  • Data Cleaning
  • Data Transformation
  • data validation
  • Date & Time Handling
  • Excel Challenges
  • ExcelBI Excel Challenges
  • ExcelBI Power Query Challenges
  • Financial Problems
  • Indexing & Ranking
  • Merging & Joining
  • Missing Values
  • Omid Challenges
  • Pivot & Unpivot
  • Power Query Challenges
  • Python Challenges
  • Text Processing
  • ⭐️ Beginner
  • ⭐️⭐️ Easy
  • ⭐️⭐️⭐️ Intermediate
  • ⭐️⭐️⭐️⭐️ Advanced
  • ⭐️⭐️⭐️⭐️⭐️Expert
  • ⭐️⭐️⭐️⭐️⭐️⭐️Complex

BYROW CHAR CODE CONCAT DROP FILTER HSTACK IF IFERROR INDEX LAMBDA LEFT LEN LET List.Distinct List.Transform LOOKUP MAP MATCH MAX MID MONTH Python Python Automation Python for Data Analysis Python for Excel REDUCE ROW ROWS SCAN SEQUENCE SORT SUBSTITUTE Table.AddColumn Table.Group Table.SelectRows TAKE Text.Combine Text.Split TEXTJOIN TEXTSPLIT TOCOL UNIQUE VSTACK XLOOKUP

Recent Posts

  • Max Total on Consecutive Days
  • Extract Valid Year Ranges
  • Swap Grid Diagonals
  • Pivot with Total Line
  • Remove One Letter Palindrome

Recent Comments

No comments to show.
Copyright © 2026 OmidBI.
Powered by WordPress and HybridMag.
  • By Difficulty
    • ⭐️ Beginner
    • ⭐️⭐️ Easy
    • ⭐️⭐️⭐️ Intermediate
    • ⭐️⭐️⭐️⭐️ Advanced
    • ⭐️⭐️⭐️⭐️⭐️Expert
    • ⭐️⭐️⭐️⭐️⭐️⭐️Complex
  • By Topic
    • Advanced Mathematics Problem
    • Aggregation & Summarization
    • Column Splitting
    • Column Transformation
    • Custom Grouping
    • Data Cleaning
    • Data Transformation
    • Date & Time Handling
    • Financial Problems
    • Indexing & Ranking
    • Merging & Joining
    • Missing Values
    • Pivot & Unpivot
    • Text Processing
  • By Creator
    • Omid Challenges
    • ExcelBI Excel Challenges
    • ExcelBI Power Query Challenges
    • Crispo Challenges
  • By Software
    • DAX Challenges
    • Excel Challenges
    • Excel VBA Challenges
    • Google Sheets Challenges
    • Office Script Challenges
    • Power Query Challenges
    • Python Challenges
    • R Challenges
    • SQL Challenges
  • Books
    • 96 Common Challenges in Power Query