Challenge No. 243: Transform the problem table into result table as shown.
Solved using: Python.
Column Transformation
Transforming column data through various operations like merging, replacing, and restructuring.
Reformat Item Entries
Challenge No. 242: Transform the problem table into result table as shown.
Solved using: Python.
Column Combining! Part 2
Challenge No. 199: Given multiple columns, concatenate them based on the order presented on the pattern column using space as a delimiter.
Solved using:Excel (BYROW, CHOOSECOLS, DROP), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Calculate Vehicle Daily Usage
Challenge No. 122: Transform the problem table into result table and work out the total number of hours a vehicle has run on a particular date.
Solved using: Power Query (List.Transform).
Transform Source to Result Table
Challenge No. 121: Transform the problem table into result table.
Solved using: Excel VBA.
Column Combining! Part 1
Challenge No. 189: Given multiple columns, concatenate them based on a predefined pattern.
Solved using:Excel (BYROW, CONCAT, IF), Google Sheets, Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip), Python, Python in Excel, and R.
Transform Input to Output
Challenge No. 55: This time problem statement is short.
Solved using: Power Query.
List Buy and Sell Balances
Challenge No. 54: From the transaction table, generate output as shown.
Solved using: Power Query.
Remove Blank Columns!
Challenge No. 79: In the question table, some columns are entirely blank.
Solved using:Excel (BYCOL, FILTER), Power Query (List.Transform, Table.Column, Table.ColumnNames), Python, Python in Excel, R, and VBA.
Merge Columns
Challenge No. 59: The power consumption of a house every 30 minutes on different dates is provided in the question table.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Power Query (List.Distinct, List.Skip, List.Split), Python, Python in Excel, and R.