You can do the split in two derived tables and then append columns, as described here: Advanced Split with Multiple Columns