Hi All,
@arrayTime = [time1, time2, time3, ......] where time value has format like 20150710 10:24:10
@arrayID = [ id1, id2, id3, id4, ....... id15]
@arrayPrice = [ Value1, Value2, Value3 ..... Value15]
I will like to produce a Matrix Report like below
id1 id2 id3 ....... id15
time1 value11 value21 vaue31 value151
time2 value21 value22 ....
time3
Thanks
David
You show @arrayPrice as having 15 values which your desired output shows as enough values to populate only one time row. Where are the other values coming from?
In order to relate a value to a time and id, there must be some way to relate them. Since @arrayID and @arrayPrice both have 15 values, I'm assuming the ordering of values matches the ordering of ids - is that correct? How do you know which time the values relate to?