3 Replies Latest reply on Nov 18, 2016 6:08 AM by Chris Beck

    Sales data without date - how to cleanup?

    Sanjay Mistry

      Hello,

       

      Here is the layout of my data in excel file. It is an extract from a larger database that we get frequently.

       

      The challenge is, columns May 14, Jun 14..... etc., are actually the sales data for that month/year. There is no date in this excel sheet.

       

      We want to be able to see sales data for each retailer by month, quarter, year, by district, by region and by area. The dollar amounts in columns below Mon-YY represent monthly sales for each store.  The unique key is the store name.

       

      Since there is not date attached, and columns sort represent the date (Mon-YY) how do I solve this puzzle? What can be done?

       

      Thanks,