I am trying to create a report of weekly demand, from a DB4 export, the
problem is sorting into the columns when my data is all mixed up, I have
tried nesting if( functions with limited success, the export is very large
with alot of different products. Any ideas?
3/9 1000 apples
3/16 800 apples
3/9 400 apples
4/12 1200 apples

Is the difficulty in finding the break point in data to place in each
column?

yes, for instance column one for week 3/14, column two week 3/21, all the
data is easy just the weekly column is the problem

"Fred" wrote:


Is the difficulty in finding the break point in data to place in each
column?