What I have to do is take the results from a database, and condense them all into one line per date. Right now, each date has numerous amounts of rows, and the data I need is spread throughout each of the rows in different columns.
Each column has the exact data value I need, and the rest of the values in that column have 0's for the other rows, until the next date.
Is there a simple way to do this? Or a difficult way? The reporting software we use (MvQuery) generates the report correctly, however can not group by period and sum that, which we need.
I'm trying to figure out a simple way to show you a mock up of the data so you can have a better idea of what I am asking, but the idea eludes me.