Challenge No. 85: Column A lists down subjects taught by Female and Male Teachers.
Solved using: SQL.
Text.Combine
Concatenates a list of text values using a specified delimiter in Power Query.
Pascal Case to Snake Case
Challenge No. 84: Change Pascal Case to Snake Case.
Solved using: Python in Excel.
Match Output to Picture
Challenge No. 83: Generate the output as shown in picture.
Solved using: SQL.
Replace Words in Original Text
Challenge No. 9: (Excel formulas also welcome)
There is a table which has Original Text and there is another table which contains the list of words which need to be replaced.
Solved using: Power Query (List.Transform, Table.AddColumn, Table.ReplaceValue).
Top Scorers by Subject
Challenge No. 20: List the distinct Subjects and Students who have scored the highest marks in those subjects along with Marks scored by them.
Solved using: Python in Excel.
Determining Missing Fields
Challenge No. 74: Customer information including Name, Family, Phone, and Website is provided in the question table.
Solved using:Excel (ARRAYTOTEXT, FILTER, HSTACK), Power Query (List.Difference, List.Distinct, Text.Combine), Python, and R.
Revisit After Surgery!
Challenge No. 42: In the question table, a list of patients is provided who are scheduled to visit the doctor for consultations and surgery.
Solved using:Excel (CHOOSECOLS, DROP, FILTER), Power Query (Text.Combine, Table.Group, Table.SelectRows), Python, and R.
Connected People!
Challenge No. 37: In the question table, the IDs of 20 people who call each other are provided.
Solved using:Excel (FILTER, HSTACK, LAMBDA), Power Query (List.Transform, Text.Combine), Python, and R.
Identifying Customers Staple Products!
Challenge No. 29: In the question table, sales transactions are listed.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Power Query (Text.Combine, Table.Group), Python, and R.
Table Transformation! Part 3
Challenge No. 21: In the question table, a list of machinery codes alongside the potential product codes each machine can produce is presented.
Solved using:Excel (FILTER, HSTACK, LAMBDA), Power Query (Text.Combine, Table.Group, Table.Sort), and R.