Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.
ISTEXT
Checks if a value is text in Excel.
Table Transformation! Part 16
Challenge No. 147: Transform the question structure into the result structure.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Skip, List.Split, Table.AddColumn), Python, Python in Excel, R, and VBA.
Sum Bird Quantity Alphabetically
Challenge No. 64: Looks like yesterday’s problem was a difficult one as only one person responded.
Solved using: Power Query (Table.Group, Table.Sort).
Separate Alphabets and Numbers
Challenge No. 2: (Excel formulas also welcome)
Extract all alphabets in one column and numbers in another column.
Solved using: Python in Excel.