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 » Challenges » By Difficulty » ⭐️⭐️⭐️ Intermediate » Page 5

⭐️⭐️⭐️ Intermediate

Moderate difficulty level.

Find Next Sparse Number
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Find Next Sparse Number

Challenge No. 512: A number is called a Sparse number if its binary form doesn’t have any two adjacent 1s.
Solved using: Python in Excel.

November 13, 2025July 23, 2025
Reshape Wide Table Format
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️ Intermediate

Reshape Wide Table Format

Challenge No. 224: Transpose the problem table into result table.
Solved using: Python.

November 12, 2025July 14, 2025
Sum Pascal Triangle Columns
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Sum Pascal Triangle Columns

Challenge No. 509: A Pascal Triangle starts with 1 at the top and each element is sum of two upper diagonal cells.
Solved using: R.

November 11, 2025July 23, 2025
Draw Alphabet Triangle
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Draw Alphabet Triangle

Challenge No. 505: Draw the triangle of alphabets as shown.
Solved using: Python in Excel.

November 9, 2025July 23, 2025
Generate Lynch Bell Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Generate Lynch Bell Numbers

Challenge No. 499: Lynch Bell Numbers – Generate the first 500 Lynch Bell Numbers starting with 2 digits.
Solved using: Excel VBA.

November 6, 2025July 23, 2025
Palindrome Count and Sum by Digit
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Palindrome Count and Sum by Digit

Challenge No. 495: Find the count and sum of Palindrome numbers for N digits Palindrome numbers.
Solved using: Python in Excel.

November 4, 2025July 23, 2025
Outstanding Loan Day Count
Posted in
  • Date & Time Handling
  • ExcelBI Power Query Challenges
  • Pivot & Unpivot
  • ⭐️⭐️⭐️ Intermediate

Outstanding Loan Day Count

Challenge No. 215: Assuming today’s date is 7-Sep-24, pivot the table as shown for Outstanding loans.
Solved using: Python in Excel.

November 3, 2025July 14, 2025
Add Task Duration to Start
Posted in
  • Date & Time Handling
  • ExcelBI Power Query Challenges
  • Pivot & Unpivot
  • ⭐️⭐️⭐️ Intermediate

Add Task Duration to Start

Challenge No. 209: Populate the End dates against all owners in a pivot format as shown.
Solved using: Python.

October 28, 2025July 14, 2025
Compile Role Based Totals
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️ Intermediate

Compile Role Based Totals

Challenge No. 206: Generate the result table from problem table.
Solved using: Python in Excel.

October 25, 2025July 14, 2025
Pivot Yes No Percentages
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️ Intermediate

Pivot Yes No Percentages

Challenge No. 205: From tables T1 and T2, generate the result table.
Solved using: Python in Excel.

October 24, 2025July 14, 2025

Posts pagination

Previous 1 … 4 5 6 … 23 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