Challenge No. 667: Pivot the data as shown.
Solved using: Python.
Text.Start
Extracts the first N characters from a text string in Power Query.
Insert Yearly Sum Totals
Challenge No. 660: Insert the sum for the year after the year ends.
Solved using: Python.
Generate Sequential Ticket Numbers
Challenge No. 620: Create the ticket numbers for each State.
Solved using: Python.
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.
Column Splitting! Part 3
Challenge No. 156: If the IDs contain an even number of characters, split them into two columns at the midpoint.
Solved using:Excel (HSTACK, IF, IFNA), Google Sheets, Power Query (List.Transform, Text.End, Text.Start), Python, Python in Excel, and R.
Find Customer Stats With Conditions
Challenge No. 44: Generate result table as shown.
Solved using: Python in Excel.
Convert Roman to Decimal
Challenge No. 154: Convert from Roman to Decimal.
Solved using: Python in Excel.
Match employee names using wildcard
Challenge No. 36: There are two tables.
Solved using: SQL.
Extract From Text! Part 1
Challenge No. 71: Extract all the emails from the text provided in the question table.
Solved using:Excel (FILTER, LEN, LET), Power Query (List.Transform, Text.Contains, Text.Split), Python, and R.