Spreadsheet: 54013d1253973542-data-sorting-helpanoob
Sheet: Sheet1

 |  | i need to format the table B4:C24 so it looks like the table J5:K35. That is the only way I can imagine creating the table M5:N35.
 |  | This is one month of data. I have 9 years, so I need to automate the process of inserting lines into the B4:C24 table to make it look like the J5:K35
 | Date | gold price$ |  | date | NokUSD | USDNOK |  |  | Date | gold price$ |  | Date | gold price NOK
 | 2009-08-03 00:00:00 | 959.75 |  | 2009-08-01 00:00:00 | 0.1618 | 6.180469715698393 |  |  | 2009-08-01 00:00:00 |  |  | 2009-08-01 00:00:00 | 0
 | 2009-08-04 00:00:00 | 960.5 |  | 2009-08-02 00:00:00 | 0.1638 | 6.105006105006105 |  |  | 2009-08-02 00:00:00 |  |  | 2009-08-02 00:00:00 | 0
 | 2009-08-05 00:00:00 | 960.5 |  | 2009-08-03 00:00:00 | 0.1638 | 6.105006105006105 |  |  | 2009-08-03 00:00:00 | 959.75 |  | 2009-08-03 00:00:00 | 5859.279609279609
 | 2009-08-06 00:00:00 | 964 |  | 2009-08-04 00:00:00 | 0.1646 | 6.075334143377886 |  |  | 2009-08-04 00:00:00 | 960.5 |  | 2009-08-04 00:00:00 | 5835.358444714459
 | 2009-08-07 00:00:00 | 956 |  | 2009-08-05 00:00:00 | 0.1657 | 6.035003017501509 |  |  | 2009-08-05 00:00:00 | 960.5 |  | 2009-08-05 00:00:00 | 5796.6203983102
 | 2009-08-10 00:00:00 | 945 |  | 2009-08-06 00:00:00 | 0.1658 | 6.031363088057901 |  |  | 2009-08-06 00:00:00 | 964 |  | 2009-08-06 00:00:00 | 5814.234016887816
 | 2009-08-11 00:00:00 | 942.75 |  | 2009-08-07 00:00:00 | 0.1659 | 6.027727546714889 |  |  | 2009-08-07 00:00:00 | 956 |  | 2009-08-07 00:00:00 | 5762.507534659434
 | 2009-08-12 00:00:00 | 947.25 |  | 2009-08-08 00:00:00 | 0.1644 | 6.082725060827251 |  |  | 2009-08-08 00:00:00 |  |  | 2009-08-08 00:00:00 | 0
 | 2009-08-13 00:00:00 | 953.5 |  | 2009-08-09 00:00:00 | 0.1637 | 6.108735491753206 |  |  | 2009-08-09 00:00:00 |  |  | 2009-08-09 00:00:00 | 0
 | 2009-08-14 00:00:00 | 953.5 |  | 2009-08-10 00:00:00 | 0.1637 | 6.108735491753206 |  |  | 2009-08-10 00:00:00 | 945 |  | 2009-08-10 00:00:00 | 5772.75503970678
 | 2009-08-17 00:00:00 | 932.75 |  | 2009-08-11 00:00:00 | 0.1629 | 6.138735420503377 |  |  | 2009-08-11 00:00:00 | 942.75 |  | 2009-08-11 00:00:00 | 5787.292817679559
 | 2009-08-18 00:00:00 | 935 |  | 2009-08-12 00:00:00 | 0.1609 | 6.215040397762586 |  |  | 2009-08-12 00:00:00 | 947.25 |  | 2009-08-12 00:00:00 | 5887.197016780609
 | 2009-08-19 00:00:00 | 943 |  | 2009-08-13 00:00:00 | 0.1616 | 6.188118811881188 |  |  | 2009-08-13 00:00:00 | 953.5 |  | 2009-08-13 00:00:00 | 5900.371287128713
 | 2009-08-20 00:00:00 | 940.5 |  | 2009-08-14 00:00:00 | 0.1652 | 6.053268765133171 |  |  | 2009-08-14 00:00:00 | 953.5 |  | 2009-08-14 00:00:00 | 5771.791767554479
 | 2009-08-21 00:00:00 | 952.5 |  | 2009-08-15 00:00:00 | 0.1654 | 6.045949214026603 |  |  | 2009-08-15 00:00:00 |  |  | 2009-08-15 00:00:00 | 0
 | 2009-08-24 00:00:00 | 951.5 |  | 2009-08-16 00:00:00 | 0.1647 | 6.07164541590771 |  |  | 2009-08-16 00:00:00 |  |  | 2009-08-16 00:00:00 | 0
 | 2009-08-25 00:00:00 | 950.5 |  | 2009-08-17 00:00:00 | 0.1647 | 6.07164541590771 |  |  | 2009-08-17 00:00:00 | 932.75 |  | 2009-08-17 00:00:00 | 5663.327261687917
 | 2009-08-26 00:00:00 | 940.5 |  | 2009-08-18 00:00:00 | 0.1628 | 6.142506142506143 |  |  | 2009-08-18 00:00:00 | 935 |  | 2009-08-18 00:00:00 | 5743.243243243243
 | 2009-08-27 00:00:00 | 943 |  | 2009-08-19 00:00:00 | 0.1629 | 6.138735420503377 |  |  | 2009-08-19 00:00:00 | 943 |  | 2009-08-19 00:00:00 | 5788.827501534684
 | 2009-08-28 00:00:00 | 955.5 |  | 2009-08-20 00:00:00 | 0.1637 | 6.108735491753206 |  |  | 2009-08-20 00:00:00 | 940.5 |  | 2009-08-20 00:00:00 | 5745.265729993891
 |  |  |  | 2009-08-21 00:00:00 | 0.1656 | 6.038647342995169 |  |  | 2009-08-21 00:00:00 | 952.5 |  | 2009-08-21 00:00:00 | 5751.811594202899
 |  |  |  | 2009-08-22 00:00:00 | 0.1666 | 6.002400960384154 |  |  | 2009-08-22 00:00:00 |  |  | 2009-08-22 00:00:00 | 0
 |  |  |  | 2009-08-23 00:00:00 | 0.167 | 5.988023952095808 |  |  | 2009-08-23 00:00:00 |  |  | 2009-08-23 00:00:00 | 0
 |  |  |  | 2009-08-24 00:00:00 | 0.167 | 5.988023952095808 |  |  | 2009-08-24 00:00:00 | 951.5 |  | 2009-08-24 00:00:00 | 5697.604790419161
 |  |  |  | 2009-08-25 00:00:00 | 0.167 | 5.988023952095808 |  |  | 2009-08-25 00:00:00 | 950.5 |  | 2009-08-25 00:00:00 | 5691.616766467065
 |  |  |  | 2009-08-26 00:00:00 | 0.1662 | 6.01684717208183 |  |  | 2009-08-26 00:00:00 | 940.5 |  | 2009-08-26 00:00:00 | 5658.844765342961
 |  |  |  | 2009-08-27 00:00:00 | 0.1655 | 6.042296072507552 |  |  | 2009-08-27 00:00:00 | 943 |  | 2009-08-27 00:00:00 | 5697.885196374622
 |  |  |  | 2009-08-28 00:00:00 | 0.165 | 6.060606060606061 |  |  | 2009-08-28 00:00:00 | 955.5 |  | 2009-08-28 00:00:00 | 5790.909090909091
 |  |  |  | 2009-08-29 00:00:00 | 0.1663 | 6.013229104028864 |  |  | 2009-08-29 00:00:00 |  |  | 2009-08-29 00:00:00 | 0
 |  |  |  | 2009-08-30 00:00:00 | 0.1659 | 6.027727546714889 |  |  | 2009-08-30 00:00:00 |  |  | 2009-08-30 00:00:00 | 0
 |  |  |  | 2009-08-31 00:00:00 | 0.1659 | 6.027727546714889 |  |  | 2009-08-31 00:00:00 |  |  | 2009-08-31 00:00:00 | 0