Challenge No. 183: In the question table, the dates are provided in various formats.
Solved using:Excel (IFERROR, INDEX, LAMBDA), Google Sheets, Power Query (Text.Split, Table.Distinct, Table.TransformColumns), Python, Python in Excel, and R.
VALUE
Converts a text string to a number in Excel.
Data Cleaning! Part 1
Challenge No. 98: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, but in a disorganized order.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Contains, Text.Split), Python, Python in Excel, and R.