+ Reply to Thread
Results 1 to 7 of 7

Converting weekly to monthly data and Yearly data to monthly

  1. #1
    Registered User
    Join Date
    01-28-2016
    Location
    Colchester, UK
    MS-Off Ver
    2010
    Posts
    6

    Lightbulb Converting weekly to monthly data and Yearly data to monthly

    Hello guys, I hope someone can help me.
    I have panel weekly data that I want to convert to monthly frequency, and also annual data that I need in monthly frequency.

    Can anyone help me out with this?

    Many thanks
    Milica

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,734

    Re: Converting weekly to monthly data and Yearly data to monthly

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    01-28-2016
    Location
    Colchester, UK
    MS-Off Ver
    2010
    Posts
    6

    Lightbulb Re: Converting weekly to monthly data and Yearly data to monthly

    Hello,

    thank you for your quick response to my question.

    I attached the workfile - as you can see I have weekly panel data that I need to convert to monthly data.

    Kind regards,
    Milica
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    397

    Re: Converting weekly to monthly data and Yearly data to monthly

    For example, you create PT, and groups in this example row labels of the years and months
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-28-2016
    Location
    Colchester, UK
    MS-Off Ver
    2010
    Posts
    6

    Re: Converting weekly to monthly data and Yearly data to monthly

    Hello,

    thank you for your response.

    Unfortuantely, I have a panel data as attached and I dont know how to take care of different variables at different times observations when creating pivot table

  6. #6
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    397

    Re: Converting weekly to monthly data and Yearly data to monthly

    https://youtu.be/iGuaCpuB3lU
    See a short video instructions, which I recorded to aid

  7. #7
    Registered User
    Join Date
    01-28-2016
    Location
    Colchester, UK
    MS-Off Ver
    2010
    Posts
    6

    Re: Converting weekly to monthly data and Yearly data to monthly

    Thank you so so so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Daily / weekly / monthly/yearly sales data
    By keeweech10 in forum Excel General
    Replies: 1
    Last Post: 03-27-2013, 04:40 AM
  2. [SOLVED] Converting yearly data in monthly data
    By RobertPrice in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2012, 12:19 PM
  3. Converting a daily data to a monthly or yearly one
    By rimajed in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 05-25-2012, 03:14 AM
  4. Replies: 1
    Last Post: 04-17-2009, 04:57 AM
  5. Converting monthly data into yearly averages
    By alcleland in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2008, 08:34 AM
  6. [SOLVED] how can list data weekly,monthly yearly etc in ms excell
    By Abdul Gaphoor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2006, 01:40 PM
  7. [SOLVED] sales data how i can list weekly,monthly yearly etc..etc...
    By Abdul Gaphoor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-01-2006, 07:20 AM
  8. Converting Weekly Data into Monthly Averages
    By Kaine in forum Excel General
    Replies: 2
    Last Post: 02-25-2005, 05:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1