Transform single record to 2 records in CSV

Hi there, I am trying to split this into 2 records as below and write it to a csv file. Can anyone suggest how I can do this? NAME ACTIVE STL_TEXT STL_CODE KRS_CODE PARENT_KRS_C...