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
Find Min Product of Three
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Find Min Product of Three

Challenge No. 537: Find the minimum product which results from multiplying any 3 numbers from N1 to N6.
Solved using: Python in Excel.

November 25, 2025July 30, 2025
Unstack Columns to Rows
Posted in
  • Column Transformation
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️ Intermediate

Unstack Columns to Rows

Challenge No. 243: Transform the problem table into result table as shown.
Solved using: Python.

November 25, 2025July 14, 2025
Fill 5×5 Grid with Index
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Fill 5×5 Grid with Index

Challenge No. 536: Put values in a 5×5 grid as per their rows and columns positions.
Solved using: R.

November 25, 2025July 30, 2025
Draw Grid by Rows/Columns
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Draw Grid by Rows/Columns

Challenge No. 535: This problem was contributed by Mehmet Çiçek.
Solved using: Python in Excel.

November 24, 2025July 30, 2025
Reformat Item Entries
Posted in
  • Column Transformation
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Reformat Item Entries

Challenge No. 242: Transform the problem table into result table as shown.
Solved using: Python.

November 24, 2025July 14, 2025
Next Palindrome with Repeats
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Next Palindrome with Repeats

Challenge No. 534: Find the next 3 Palindrome numbers for the given numbers where any digit is repeated by the numbers given in Repeats column.
Solved using: Python in Excel.

November 24, 2025July 30, 2025
Draw Symmetric Star in ASCII
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Draw Symmetric Star in ASCII

Challenge No. 533: Draw ASCII star for given N which is an odd number for the purpose of symmetry.
Solved using: Python in Excel.

November 23, 2025July 30, 2025
Spread Yearly Rows to Columns
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Spread Yearly Rows to Columns

Challenge No. 240: Transpose the problem table into result table as shown.
Solved using: R.

November 23, 2025July 14, 2025
Sum-Based Neighboring Grid Fill
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Sum-Based Neighboring Grid Fill

Challenge No. 532: Apologies!! Scheduling didn’t work today.
Solved using: Python in Excel.

November 23, 2025July 30, 2025
Remove Digit to Make Divisible
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Remove Digit to Make Divisible

Challenge No. 531: List first 500 numbers starting with 101 which don’t end with 0 and are divisible at least once by removing one digit at a time from the number.
Solved using: R.

November 22, 2025July 30, 2025

Posts pagination

Previous 1 … 18 19 20 … 117 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