+ Reply to Thread
Results 1 to 2 of 2

turn monthly data into daily!Regression

  1. #1
    Registered User
    Join Date
    Heidelberg, Germany
    MS-Off Ver
    Excel 2010

    turn monthly data into daily!Regression

    Hi everybody!

    Is there any lean way that won't take too long for converting monthly data into daily data?

    The purpose of the data is to make a regression. Since one parameter is daily and to have more observations I would like to turn the 2nd parameter into daily data as well ( I know it will be quite static):
    So January value should be 31 times the same etc...

    Can I do that with pivot?

    Thanks very much!

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast

    Re: turn monthly data into daily!Regression


    this depends a bit on how your data is structured. If the monthly data is labeled with real dates, for example 1-Jan-2011, then you can create a column with dates and use Vlookup


    See attached.

    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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