Challenge No. 72: Transpose the data in a single row for all departments.
Solved using: Power Query (List.Transform).
TEXTSPLIT
Splits a text string into an array based on delimiters in Excel.
Decode Numbered Character Words
Challenge No. 227: In column A, characters are separated by 1.
Solved using: Power Query.
Sort Numbers Leave Text
Challenge No. 226: Sort the numbers in given strings and leave the non numbers as they are.
Solved using: Power Query.
Count Consecutive 1s Only
Challenge No. 221: Count the number of 1s if they are consecutive.
Solved using: Power Query.
Find Co-Prime Pairs
Challenge No. 214: Co-prime numbers are those numbers whose Highest Common Factor (Highest Common Divisor) is 1.
Solved using: Power Query (List.Transform).
Detect Ascending or Descending
Challenge No. 211: Find whether the numbers given in column A are in Ascending order or Descending Order.
Solved using: Power Query.
Number Each Character
Challenge No. 209: Insert 1., 2.
Solved using: Power Query (List.Transform).
Classify Items as Used or New
Challenge No. 60: Generate the Result table from Problem table.
Solved using: Power Query (Table.AddColumn, Table.Split, Table.SplitColumn).
Column Splitting! Part 1
Challenge No. 136: Split the ID values where a character is repeated consecutively.
Solved using:Excel (CONCAT, DROP, IF), Google Sheets, Power Query (List.Transform, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
Trim Characters Before Asterisk
Challenge No. 194: Remove the characters preceding the asterisks.
Solved using: Power Query.