P
Paul
I have a table with multiple fields on it. I need to create another table
base on the first table but require to transform 8 to 9 fields from the
first table and store it as a record in the second table like the example
below. Is there a way to transform it using vba code and I do not want to do
it manually as there are over 20000 records in the first table. Just like
the crosstab query but reverse!
First Table
ID Paul John Mary
1 Good Bad Good
2 Worst Bad
3 Ok Worst
Seocnd Table
ID Name Comment
1 Paul Good
2 John Bad
3 Mary Good
4 Paul Worst
5 John
6 Mary Bad
7 Paul OK
8 John Worst
9 Mary
Thanks
base on the first table but require to transform 8 to 9 fields from the
first table and store it as a record in the second table like the example
below. Is there a way to transform it using vba code and I do not want to do
it manually as there are over 20000 records in the first table. Just like
the crosstab query but reverse!
First Table
ID Paul John Mary
1 Good Bad Good
2 Worst Bad
3 Ok Worst
Seocnd Table
ID Name Comment
1 Paul Good
2 John Bad
3 Mary Good
4 Paul Worst
5 John
6 Mary Bad
7 Paul OK
8 John Worst
9 Mary
Thanks