So you want to split Price and Value in exactly halves, and Units halves rounded to the lower value for the first record (and upper for the second record)?
Not sure if this will depict "the truth", so you probably need to document this rule for data conumers.
From a data integrity perspective it would make more sense to merge the records instead, or try to find the original records that contributes to your numerival columns with date specifications.
That being said - there's not really an OOTB transformation for this, so probably a User Written data step is required. While doing so, make sure you use as many of the DI Studio generated macro variables in your code to make it more flexible and resilant for changes over time.
Data never sleeps
