• You can always PIVOT your results after splitting. Would that work for you?

    -- Gianluca Sartori