breakdown a DB4 export into an excel worksheet

[Jim e boy]

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

 

[Fred]

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

 

[Jim e boy]

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