Indeed split recipe splits on rows. If you want to create new rows from existing columns and then split, then use a prepare recipe first. In the prepare recipe you will find several processors under the 'Reshaping' section that should be able to help you get your dataset in the desired state before splitting.