Can someone help me help me how to create a macro that would transpose the following amount in column to rows that match the dates, here is an example:
Raw data from sheet 1:
<colgroup><col><col></colgroup><tbody>
</tbody>
Result in Sheet 2:
<colgroup><col span="3"><col><col span="3"><col span="2"><col span="3"><col><col></colgroup><tbody>
</tbody>
Raw data from sheet 1:
Date | Amount |
Oct 14, 2017 | 1 |
Oct 21, 2017 | 2 |
Oct 28, 2017 | 3 |
Nov 4, 2017 | 4 |
Nov 11, 2017 | 5 |
Nov 18, 2017 | 6 |
Nov 25, 2017 | 7 |
Dec 2, 2017 | 8 |
Dec 9, 2017 | 9 |
Dec 16, 2017 | 10 |
Dec 23, 2017 | 11 |
Dec 30, 2017 | 12 |
Jan 6, 2018 | 13 |
Jan 13, 2018 | 14 |
Oct 14, 2017 | 15 |
Oct 21, 2017 | 16 |
Oct 28, 2017 | 17 |
Nov 4, 2017 | 18 |
Nov 11, 2017 | 19 |
Nov 18, 2017 | 20 |
Nov 25, 2017 | 21 |
Dec 2, 2017 | 22 |
Dec 9, 2017 | 23 |
Dec 16, 2017 | 24 |
Dec 23, 2017 | 25 |
Dec 30, 2017 | 26 |
Jan 6, 2018 | 27 |
Jan 13, 2018 | 28 |
Oct 14, 2017 | 29 |
Oct 21, 2017 | 30 |
Oct 28, 2017 | 31 |
Nov 4, 2017 | 32 |
Nov 11, 2017 | 33 |
Nov 18, 2017 | 34 |
Nov 25, 2017 | 35 |
Dec 2, 2017 | 36 |
Dec 9, 2017 | 37 |
Dec 16, 2017 | 38 |
Dec 23, 2017 | 39 |
Dec 30, 2017 | 40 |
Jan 6, 2018 | 41 |
Jan 13, 2018 | 42 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Result in Sheet 2:
Oct 14, 2017 | Oct 21, 2017 | Oct 28, 2017 | Nov 4, 2017 | Nov 11, 2017 | Nov 18, 2017 | Nov 25, 2017 | Dec 2, 2017 | Dec 9, 2017 | Dec 16, 2017 | Dec 23, 2017 | Dec 30, 2017 | Jan 6, 2018 | Jan 13, 2018 |
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 |
<colgroup><col span="3"><col><col span="3"><col span="2"><col span="3"><col><col></colgroup><tbody>
</tbody>