2 Replies Latest reply on May 2, 2014 3:24 PM by Stephen Lagano

    add units from two different data sources with different headings

    Stephen Lagano

      I have two excel spreadsheets with similar but different information. The similar information is units and the different information is the headers for the date and units.

       

      I want to combine these two data sources to get a weekly, monthly, etc. view of total units from the two sources

       

      File #1 Headers: Date shipped and Items Shipped

      File #2 Headers: Date delivered and Items Delivered