Arrange Data Matrix into List for Access
Hello,
Using Access for a number of calculation and have a lot of source data
in this format:
Name OCT NOV DEC
A 0 1 1
B 1 0.5 0
C 1 0 0
D 1 1 1
That I need to rearrange into this format:
A OCT 0
B OCT 1
C OCT 1
D OCT 1
A NOV 1
B NOV 0.5
C NOV 0
D NOV 1
A DEC 1
B DEC 0
C DEC 0
D DEC 1
I have some simple code for set ranges but ideally want to be able to
run one macro for differening number rows and columns.
Any help appreciated.
|