darrenliux
New Member
- Joined
- May 13, 2018
- Messages
- 15
Hi
I'm looking for a VBA code to solve the problem below, the input will start in Cell I2. I'd really appreciate any help on this.
Raw input table:
<tbody>
</tbody>
to consolidate data to (Solution is under the original data)
<tbody>
</tbody>
Thank you in advance for any help
I'm looking for a VBA code to solve the problem below, the input will start in Cell I2. I'd really appreciate any help on this.
Raw input table:
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
1 | ||||||||||||||||||
2 | 2000 | 2001 | 2002 | 2003 | 2000 | 2001 | 2002 | 2003 | ... to continue up to 30 columns | |||||||||
3 | 1 | 2 | 3 | 4 | 9 | 9 | 9 | 9 | ||||||||||
4 | ||||||||||||||||||
5 | ||||||||||||||||||
6 |
<tbody>
</tbody>
to consolidate data to (Solution is under the original data)
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
1 | ||||||||||||||||||
2 | 2000 | 2001 | 2002 | 2003 | 2000 | 2001 | 2002 | 2003 | ...to continue up to 30 columns | |||||||||
3 | 1 | 2 | 3 | 4 | 9 | 9 | 9 | 9 | ||||||||||
4 | 2000 | 2001 | 2002 | 2003 | ||||||||||||||
5 | 10 | 11 | 12 | 13 | ||||||||||||||
6 |
<tbody>
</tbody>
Thank you in advance for any help