Hi Guys,
Anyone can come up with an VBA which can help to rearranging database?
Please refer to the following.
Original:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Desire:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Basically
1. Put header in front of the date column.
2. Copy and paste the corresponding amount to the third column.
This case I show is simplified case. I have 50+ column I need to rearrange to this format.
I am thinking there will be some kind of VBA to loop through the process.
Much appreciate the help.
Logit I know you are here to help.
Anyone can come up with an VBA which can help to rearranging database?
Please refer to the following.
Original:
| Row Labels | Sum of HG658 VDSL - iiNet | Sum of VR1600v (FTTN) |
| Jan-17 | 1100 | 0 |
| Feb-17 | 102 | 0 |
| Mar-17 | 144 | 0 |
| Apr-17 | 756 | 0 |
| May-17 | 1050 | 0 |
| Jun-17 | 96 | 0 |
| Jul-17 | 0 | 0 |
| Aug-17 | 80 | 1108 |
| Sep-17 | 56 | 780 |
| Oct-17 | 864 | 0 |
| Nov-17 | 20 | 1700 |
| Dec-17 | 0 | 7120 |
| Jan-18 | 0 | 796 |
| Feb-18 | 0 | 707 |
| Mar-18 | 0 | 114 |
| Apr-18 | 0 | 11251 |
| May-18 | 0 | 1279 |
| Jun-18 | 0 | 1337 |
| Jul-18 | 0 | 1416 |
| Aug-18 | 0 | 650 |
| Sep-18 | 0 | 0 |
| Oct-18 | 0 | 0 |
| Nov-18 | 0 | 0 |
| Dec-18 | 0 | 0 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Desire:
| Sum of HG658 VDSL - iiNet | Jan-17 | 1100 |
| Sum of HG658 VDSL - iiNet | Feb-17 | 1032 |
| Sum of HG658 VDSL - iiNet | Mar-17 | 1454 |
| Sum of HG658 VDSL - iiNet | Apr-17 | 756 |
| Sum of HG658 VDSL - iiNet | May-17 | 1050 |
| Sum of HG658 VDSL - iiNet | Jun-17 | 96 |
| Sum of HG658 VDSL - iiNet | Jul-17 | 0 |
| Sum of HG658 VDSL - iiNet | Aug-17 | 840 |
| Sum of HG658 VDSL - iiNet | Sep-17 | 576 |
| Sum of HG658 VDSL - iiNet | Oct-17 | 864 |
| Sum of HG658 VDSL - iiNet | Nov-17 | 720 |
| Sum of HG658 VDSL - iiNet | Dec-17 | 0 |
| Sum of HG658 VDSL - iiNet | Jan-18 | 0 |
| Sum of HG658 VDSL - iiNet | Feb-18 | 0 |
| Sum of HG658 VDSL - iiNet | Mar-18 | 0 |
| Sum of HG658 VDSL - iiNet | Apr-18 | 0 |
| Sum of HG658 VDSL - iiNet | May-18 | 0 |
| Sum of HG658 VDSL - iiNet | Jun-18 | 0 |
| Sum of HG658 VDSL - iiNet | Jul-18 | 0 |
| Sum of HG658 VDSL - iiNet | Aug-18 | 0 |
| Sum of HG658 VDSL - iiNet | Sep-18 | 0 |
| Sum of HG658 VDSL - iiNet | Oct-18 | 0 |
| Sum of HG658 VDSL - iiNet | Nov-18 | 0 |
| Sum of HG658 VDSL - iiNet | Dec-18 | 0 |
| Sum of VR1600v (FTTN) | Jan-17 | 0 |
| Sum of VR1600v (FTTN) | Feb-17 | 0 |
| Sum of VR1600v (FTTN) | Mar-17 | 0 |
| Sum of VR1600v (FTTN) | Apr-17 | 0 |
| Sum of VR1600v (FTTN) | May-17 | 0 |
| Sum of VR1600v (FTTN) | Jun-17 | 0 |
| Sum of VR1600v (FTTN) | Jul-17 | 0 |
| Sum of VR1600v (FTTN) | Aug-17 | 11208 |
| Sum of VR1600v (FTTN) | Sep-17 | 7680 |
| Sum of VR1600v (FTTN) | Oct-17 | 0 |
| Sum of VR1600v (FTTN) | Nov-17 | 10700 |
| Sum of VR1600v (FTTN) | Dec-17 | 7120 |
| Sum of VR1600v (FTTN) | Jan-18 | 796 |
| Sum of VR1600v (FTTN) | Feb-18 | 7707 |
| Sum of VR1600v (FTTN) | Mar-18 | 11104 |
| Sum of VR1600v (FTTN) | Apr-18 | 11251 |
| Sum of VR1600v (FTTN) | May-18 | 12079 |
| Sum of VR1600v (FTTN) | Jun-18 | 13317 |
| Sum of VR1600v (FTTN) | Jul-18 | 14816 |
| Sum of VR1600v (FTTN) | Aug-18 | 6504 |
| Sum of VR1600v (FTTN) | Sep-18 | 0 |
| Sum of VR1600v (FTTN) | Oct-18 | 0 |
| Sum of VR1600v (FTTN) | Nov-18 | 0 |
| Sum of VR1600v (FTTN) | Dec-18 | 0 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Basically
1. Put header in front of the date column.
2. Copy and paste the corresponding amount to the third column.
This case I show is simplified case. I have 50+ column I need to rearrange to this format.
I am thinking there will be some kind of VBA to loop through the process.
Much appreciate the help.
Logit I know you are here to help.
