Shweta
Well-known Member
- Joined
- Jun 5, 2011
- Messages
- 514
Hi All,
I need a macro to change the format of a data.
<colgroup><col width="64" span="4" style="width: 48pt; text-align: center;"> </colgroup><tbody>
</tbody>
Data is given in the above format and I need to arrange the data in below format. Data is for a month so it is difficult to do it manually.
<colgroup><col width="64" span="3" style="width: 48pt; text-align: center;"> </colgroup><tbody>
</tbody>
Please help me out with a macro.
Thanks in advance!
Regards,
Shweta
I need a macro to change the format of a data.
NAME | 01-04-13 | 02-04-13 | 03-04-13 |
A | 15 | 9 | 10 |
B | 2 | 47 | 16 |
C | 22 | 30 | 34 |
D | 45 | 24 | 49 |
E | 50 | 34 | 6 |
F | 37 | 23 | 38 |
G | 48 | 32 | 43 |
H | 33 | 45 | 50 |
I | 11 | 3 | 12 |
J | 2 | 8 | 22 |
<colgroup><col width="64" span="4" style="width: 48pt; text-align: center;"> </colgroup><tbody>
</tbody>
Data is given in the above format and I need to arrange the data in below format. Data is for a month so it is difficult to do it manually.
DATE | NAME | NUMBERS |
01-04-13 | A | 15 |
01-04-13 | B | 2 |
01-04-13 | C | 22 |
01-04-13 | D | 45 |
01-04-13 | E | 50 |
01-04-13 | F | 37 |
01-04-13 | G | 48 |
01-04-13 | H | 33 |
01-04-13 | I | 11 |
01-04-13 | J | 2 |
02-04-13 | A | 9 |
02-04-13 | B | 47 |
02-04-13 | C | 30 |
02-04-13 | D | 24 |
02-04-13 | E | 34 |
02-04-13 | F | 23 |
02-04-13 | G | 32 |
02-04-13 | H | 45 |
02-04-13 | I | 3 |
02-04-13 | J | 8 |
03-04-13 | A | 10 |
03-04-13 | B | 16 |
03-04-13 | C | 34 |
03-04-13 | D | 49 |
03-04-13 | E | 6 |
03-04-13 | F | 38 |
03-04-13 | G | 43 |
03-04-13 | H | 50 |
03-04-13 | I | 12 |
03-04-13 | J | 22 |
<colgroup><col width="64" span="3" style="width: 48pt; text-align: center;"> </colgroup><tbody>
</tbody>
Please help me out with a macro.
Thanks in advance!
Regards,
Shweta