Challenge No. 692: List the team which won all their matches.
Solved using: Python in Excel.
TEXTAFTER
Extracts the text after a specified delimiter in Excel.
Match Names with Same Initials
Challenge No. 612: List the names if first character of first name and first character of last name are same.
Solved using: Python.
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.
Pivot the problem table into
Challenge No. 251: Pivot the problem table into result table.
Solved using: Python.
Score Matrix for Team Matches
Challenge No. 482: Prepare the given matrix from problem table.
Solved using: Python in Excel.
Split Delimited Text into Columns
Challenge No. 433: Split the given text into columns.
Solved using: R.
Validate Point Connectivity Rule
Challenge No. 395: Coordinates for points are given in x, y format.
Solved using: DAX.
People Connection!
Challenge No. 200: In the question table, direct connections between people are provided.
Solved using:Excel (IF, IFNA, INDEX), Power Query (List.Transform, Text.End), Python, Python in Excel, and R.
Generate Soundex Codes
Challenge No. 128: Every Soundex code consists of a letter and three numbers, such as W-252.
Solved using: R.
Column Splitting! Part 5
Challenge No. 191: If an ID contains multiple separators (like -, _, .
Solved using:Excel (HSTACK, LAMBDA, LEN), Google Sheets, Power Query (Text.PositionOf, Table.AddColumn, Table.FromRows), Python, Python in Excel, and R.