I have an import from a parent company that delivers data like this.
Example
Import (today, this import shows a record = week of sales)
Store ID, Item #, WeekofYear, Monday Sales, Tuesday Sales, Wednesday Sales Thursday Sales, Friday Sales
I would like to convert as the records load to another table as a Record = Daily Sale.
Store ID, Item#, WeekofYear, Monday Sales
Store ID, Item#, Week of Year, Tuesday Sales
Store ID, Item#, Week of Year, Wednesday Sales
etc
etc..
Therefore a record = day.
Any ideas?
E...