Challenge No. 681: Split and align the data as shown.
Solved using: Python in Excel.
Column Splitting
Techniques and methods for splitting columns in data processing.
Carriage Return
Challenge No. 67: Split the data into separate rows
Combined data is separated by a carriage return
Not all rows have carriage returns
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
Split Data by Capital Letters
Challenge No. 190: Split the data into columns.
Solved using: R.
Split Delimited Text into Columns
Challenge No. 433: Split the given text into columns.
Solved using: R.
Split and Running Total Rows
Challenge No. 176: Generate the result table from problem table.
Solved using: Python in Excel.
Split by Alpha-Numeric Change
Challenge No. 417: Split the given strings whenever a changeover happens between English alphabets and numbers.
Solved using: Excel VBA.
Split on First Greater Sum
Challenge No. 378: Split the numbers into two parts where sum of first part is > sum of second part where it happens for the first time.
Solved using: R.
Monthly Per Diem Calculation
Challenge No. 149: The data is for business trip start and end dates of employees.
Solved using: Python.
Column Splitting! Part 6
Challenge No. 196: Split the ID into two columns:
The first column should contain all letters.
Solved using:Excel (CONCAT, HSTACK, LAMBDA), Google Sheets, Power Query (List.Transform, Text.Select, Table.AddColumn), Python, Python in Excel, and R.
Text Split
Challenge No. 57: Split the group of texts into single characters
Dynamic array function allowed, but extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.