@buran - you are probably right. What tebbens is probably looking at is a cross-query output. The data does exist in the correct format in the database and is "stretched out" for displays to humans. A straight query to get the data in normalized format is probably what is really needed here.
I pull data from Oracle all the time in a normalized format and use the Excel table it comes into to do some computations and to play with pivot tables and charts. Database + Excel is a winning combination if done right.
Bookmarks