As I receive it...
Code Desc 1/1/2012 8/1/201 15/01/2012
BX24272 Red Lever Arch File 45 63 72
QC76354 Black Ring Binder 11 18 26
How I would like it...
Code Desc Volume Week Month Year
BX24272 Red Lever Arch File 45 1 Jan 2012
QC76354 Black...
Hi Luke,
Happy Friday!
Yes of course.....
So this is basically what my data looks like when it comes in.
Code Description 01/01/2012 08/01/2012 15/01/2012
BX27464 Red Lever Arch File 67 42 57
QR43537 Black Ring Binder...
Hello there!
I work with pivot tables a lot and would really like to know if an Excel Wizard out there could help me with a shortcut or some advise please...
I often recieve large amounts of sales data, and it is set up to show each product's volume sold in a column for each weeks data...