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

Splitting and Combining Pandas Columns into Separate Rows Using str.split() and explode()