+ Reply to Thread
Results 1 to 2 of 2

turn monthly data into daily!Regression

  1. #1
    Registered User
    Join Date
    12-17-2011
    Location
    Heidelberg, Germany
    MS-Off Ver
    Excel 2010
    Posts
    1

    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 Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: turn monthly data into daily!Regression

    Hello,

    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

    =VLOOKUP(DATE(YEAR(D2),MONTH(D2),1),$A$2:$B$4,2,FALSE)

    See attached.

    cheers,
    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)

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