title: Line Up Two Columns of Timestamped Data in Excel
body: <p>I am trying to analyze the relationship between Bitcoin Market Price and Google Search Trends for the word "Bitcoin." For the former, I am using the <a href="https://blockchain.info/charts/market-price?timespan=all&amp;showDataPoints=false&amp;daysAverageString=1&amp;show_header=true&amp;scale=0&amp;address=" rel="nofollow noreferrer">chart found at blockchain.info</a> downloaded in .CSV format; for the latter, I am using Google Trends data (search "Bitcoin" in the Google Trends page), also downloaded in .CSV format. I am planning to graph them against each other in Excel, do some math on them, etc... The issue is, Google Trends data is logged weekly, while Blockchain.info data is logged daily. This means the resulting rows don't line up after the first data point:</p>
  
  <p><a href="https://i.stack.imgur.com/RDGUd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RDGUd.png" alt="Excel Workbook Screenshot"></a></p>
  
  <p>Is there a quick shortcut I can use to spread out the Google Trends data, so that the dates in each row match (and so that there are blank A and B rows where data does not exist for a given date in the blockchain data)? Any and all help greatly appreciated!</p>
  
  <p>NOTE: I realize analyses of these data have been performed before; I want to do them myself for self-educational purposes.</p>