breakdown a DB4 export into an excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing occurrences within a list 2
Compare two datasheets and create a new one with modified and newinformation - Excel 1
How can I separate a large spreadsheet into worksheets? 5
Lookup value then return result from other column, varying row num 5
Data selection from one worksheet into a second worksheet. 1
Can't get an Excel spreadshe doc. to export into Oultook Contacts 1
Tie a Calendar week to a Scoped Projected Week 3
Easy question for you, but hard for me. 3

Back
Top