3 Replies Latest reply on Dec 9, 2016 11:57 AM by Sanjay Mistry

    Weekly Data - how to join/blend?

    Sanjay Mistry

      Hello,

       

      I have weekly data in the following structure. Columns A through M. For each week, there will be a separate tab. As week passes by, folders will grow. Most of the time columns A (material number) will have same rows but once in a while we add new products so new rows show up.

       

      Questions:

      1.  How do I connect to this data set -  Shall I join these tabs or blend? I think blending would be a better option but then what to do when new products show up?

       

      The objective is to create weekly comparison of $, % chg etc.

       

      Thanks,