I have sales guys inputting projections by customer, product, and month
Their input pages it looks something like this:
COSTCO
Jan Feb Mar Apr
VEGETABLE SOUP 20 30
CHICKEN SOUP 40 50
Total Soup 20 70 50
ORANGE JUICE 10 10 10 10
GRAPE JUICE 20
APPLE JUICE 20
Total Juice 30 10 30 10
What I want is to get a flat table out of this that looks more like this:
Customer Product Month Sales
COSTCO VEG SOUP Jan 20
COSTCO VEG SOUP Feb 30
COSTCO CHX SOUP Feb 40
COSTCO CHX SOUP Mar 50
So I can then get it in an access database and slice and dice it however I want.
any ideas that are not too cumbersome ( as of right now there are about 200 products and 100 customers... and we project out 18 months.
Their input pages it looks something like this:
COSTCO
Jan Feb Mar Apr
VEGETABLE SOUP 20 30
CHICKEN SOUP 40 50
Total Soup 20 70 50
ORANGE JUICE 10 10 10 10
GRAPE JUICE 20
APPLE JUICE 20
Total Juice 30 10 30 10
What I want is to get a flat table out of this that looks more like this:
Customer Product Month Sales
COSTCO VEG SOUP Jan 20
COSTCO VEG SOUP Feb 30
COSTCO CHX SOUP Feb 40
COSTCO CHX SOUP Mar 50
So I can then get it in an access database and slice and dice it however I want.
any ideas that are not too cumbersome ( as of right now there are about 200 products and 100 customers... and we project out 18 months.