Challenge No. 606: Merge rows on the basis of names.
Solved using: Python.
Merging & Joining
Merging multiple datasets in different tools.
Sum and Sort Student Marks
Challenge No. 244: Merge both problem tables into one by summing marks for common entries.
Solved using: Python.
Matrix Merge With Totals
Challenge No. 213: Merge the 2 tables and pivot them on Item with Total Row and Total Column.
Solved using: Python in Excel.
Merge Tables by Org and Year
Challenge No. 478: Merger the tables into a single table.
Solved using: Python.
Merge Subject Maximum Marks
Challenge No. 200: Merge the two tables by taking maximum marks of the subject.
Solved using: Python in Excel.
Match Deliveries with Calendar Dates
Challenge No. 186: Merge both the tables.
Solved using: Python in Excel.
Extract Ending Pattern Group
Challenge No. 184: Extract the last group of alphabets followed by numbers in each Text and concat them with a dash in between for each Set.
Solved using: Python.
Normalize Table from Merged Cells
Challenge No. 409: This challenge was contributed by Taeyong Shin
Unmerge merged cells, separate characters separated by delimiters, and create a normalized table.
Solved using: Python in Excel.
Concatenated Multiples All Digits
Challenge No. 274: List those numbers when a number is multiplied by 2 once and 3 once and we join the original number with results of these multiplications, then the result should contain all digits from 0 through 9.
Solved using: Python in Excel.
Merge! Part 3
Challenge No. 132: In Question Table 1, values are provided for each code.
Solved using:Excel (FILTER, FIND, ISNUMBER), Google Sheets, Power Query (Text.Contains, Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and VBA.