Splitting a Column into Multiple Columns Dynamically in Python or SQL

Here's a more detailed explanation of how to achieve this using Python:

Counting NaN Rows in a Pandas DataFrame with 'Unnamed' Column