Auto transcribe data from MDB to XLS
Ideally I'd like it columnular:
Time - Data 1 - Data 2 - Data 3 ------
Time1 - Value1 - Value2 - Value3 ------
But it appears the MDB is stored as blocks of data in rows ROUGHLY by time (see attached).
"ItemID" is a value that corresponds with a certain type of data I am logging - 38 may be one temperature zone and 37 another. "NumValue" is the numeric value of that data - for example From 8:18:05 to 18:18:35, data 38 (a temperature) had an actual value of 20.
If I could condense this to the tabular type of data above for each ItemID (I have probably 15) with values and corresponding times, that is the goal.
Note that not all ItemID's have the same time spacing. This isn't really important to me - each data set could have its own associated time, that's fine.