Please see if the attached could be a first step.
In general, I used INDEX() and adjusted the Addressing and Partitioning.
For RN_Tank, I used the setup as shown in the first graphic below.
For RN_Batch, I used a different one, as shown in the second below.
Of note: I couldn't exactly sort the data in the order you have in the table above
(i.e. couldn't get Batch123-Date1/12/11-Value1-5 to come after Batch123.
Is there some other dimension that could be used to sort it in that way?
212831tank.twbx 16.9 KB