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 » ⭐️ Beginner » Page 2

⭐️ Beginner

Easy challenges for newcomers.

Align Names With Amounts
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Align Names With Amounts

Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.

February 7, 2026July 21, 2025
Grid Lookup By Pattern
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Grid Lookup By Pattern

Challenge No. 683: Find the value corresponding to numbers given in column N from the grid given of left hand side.
Solved using: Python.

February 6, 2026July 21, 2025
Split And Sum Orders
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Split And Sum Orders

Challenge No. 682: In the problem table, if there are more than one order number, then amount will be equally divided among order numbers.
Solved using: Python.

February 6, 2026July 21, 2025
Split And Align Columns
Posted in
  • Column Splitting
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Split And Align Columns

Challenge No. 681: Split and align the data as shown.
Solved using: Python in Excel.

February 5, 2026July 21, 2025
Quarterly Payment Grouping
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Quarterly Payment Grouping

Challenge No. 676: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Divide the payments among different quarters / months.
Solved using: R.

February 3, 2026July 21, 2025
Draw Star Shape Pattern
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Draw Star Shape Pattern

Challenge No. 673: Create the star patterns for given N.
Solved using: R.

February 1, 2026July 21, 2025
Transpose Table With Profit
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Transpose Table With Profit

Challenge No. 670: Transpose the table as shown.
Solved using: Python.

January 31, 2026July 21, 2025
Pivot Data To Columns
Posted in
  • ExcelBI Excel Challenges
  • Pivot & Unpivot
  • ⭐️ Beginner

Pivot Data To Columns

Challenge No. 667: Pivot the data as shown.
Solved using: Python.

January 29, 2026July 21, 2025
Fill Missing With Average
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Fill Missing With Average

Challenge No. 666: Fill in the blanks with (Total – Sum of non Blanks Values)/Number of Blanks
Hence for row 3: (580-(170+150))/1 = 260
For row 7: (440-90)/2 = 175
For row 9: (360-0)/3 = 120.
Solved using: Python.

January 29, 2026July 21, 2025
Bi And Trimorphic Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Bi And Trimorphic Numbers

Challenge No. 665: Bi & Trimorphic Numbers – List numbers (n<100000) if n^3 and n^2 both end with n. Solved using: Python.

January 28, 2026July 21, 2025

Posts pagination

Previous 1 2 3 … 41 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