With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, December 7, 2014
yogi_Given Columns Of Dates And Prices Rearrage Price1 Price2 Price3 By Date In Ascending Order
post by Tyler Goldberg: https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/BdcJ_-_rJ4Y Combining sets of data with different timelines
I have multiple sets of data that each have two columns, date and price. The problem is there is one data point for only business days and each year has different business days. Here is an example of the data sets:
Date1 Price1 Date2 Price2 Date3 Price3
1/1 5 1/1 9 1/1 15
1/2 6 1/4 10 1/2 14
1/3 6 1/5 11 1/5 13
1/4 7 1/6 12 1/6 14
So after copying and pasting the data sets next to each other, this is how the data looks. The problem is none of the dates line up. How can I sort the data to where they are all on the same timeline? There are going to be data gaps but that isn't a problem.