Sunday, December 7, 2014

yogi_Given Columns Of Dates And Prices Rearrage Price1 Price2 Price3 By Date In Ascending Order

              Google Spreadsheet   Post  #1858
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-07-2014
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.
------------------------------------------------------------------------------------------------------------------