Results 1 to 2 of 2

Thread: Multiple Products by Month over multiple years
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2003
    Posts
    165
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Multiple Products by Month over multiple years

    Good day,

    I have a need to consolidate monthly sales data from multiple years for many products. The sales data is in a spreadsheet for each year. The products sold have had some added and some discontinued over the years, and currently an overall master list does not exist that covers this. The data for each yearly spreadsheet is in the form where the product name is in column A, row 5 is the last day of the month and used as the header for the month, and then the monthly sales fill in the respective cells. I first need to take all this data and create an overall list where I would have the product name in column A, the last day of the month in column B and then the sales for that month in column C. I need this format as then analysis requires multiple scenarios such as yearly changes, yearly peaks, seasonality, and more.

    What is the best method to make the consolidated list since the products have changed over the last 10 years.

    Thanks in advance for your assistance.

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Multiple Products by Month over multiple years

    Hello,

    Have you tried to Insert a Pivot Table ...

    Hope this will help

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •