Hi,
I have a set of data in the following format which I want to have in the simplified format as mentioned below on Sheet2.
Since the data volume is quite huge, can it possible to write a macro for this.
please help.
Thanks in Advance.
I have a set of data in the following format which I want to have in the simplified format as mentioned below on Sheet2.
Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Sheet1 | ||||||||||
2 | ONMOB123 | 0 | 0 | 0 | 0 | ||||||
3 | 0 | 904030 | 79066057 | 0 | |||||||
4 | |||||||||||
5 | DASONMOB | 0 | 0 | 0 | 1000 | ||||||
6 | 39142 | 0 | 0 | 0 | |||||||
7 | |||||||||||
8 | OLDMCA | 0 | 0 | 0 | 0 | ||||||
9 | 0 | 0 | 0 | 0 | |||||||
10 | |||||||||||
11 | Sheet2 | ||||||||||
12 | |||||||||||
13 | ONMOB123 | 0 | 0 | 0 | 0 | 0 | 904030 | 79066057 | 0 | ||
14 | DASONMOB | 0 | 0 | 0 | 1000 | 39142 | 0 | 0 | 0 | ||
15 | OLDMCA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
16 | |||||||||||
Sheet1 |
Since the data volume is quite huge, can it possible to write a macro for this.
please help.
Thanks in Advance.