A
Al
Hello,
Hope someone can give advice on how to do this. I have inherited a database
with a large table in it that has 5 fields; field 1 is text, fields 2,3,4 and
5 are integer values. How do I rearrange this to form a new table that has
only two fields in it; the existing field 1 and a new second field which has
all the individual values previously held in fields 2,3,4 and 5?
So from this:-
Field1 Field2 Field3 Field4 Field5
A 2 22 44 57
B 45 12 3 8
To this:-
Field1 Field2
A 2
A 22
A 44
A 57
B 45
B 12 etc
Thanks
Hope someone can give advice on how to do this. I have inherited a database
with a large table in it that has 5 fields; field 1 is text, fields 2,3,4 and
5 are integer values. How do I rearrange this to form a new table that has
only two fields in it; the existing field 1 and a new second field which has
all the individual values previously held in fields 2,3,4 and 5?
So from this:-
Field1 Field2 Field3 Field4 Field5
A 2 22 44 57
B 45 12 3 8
To this:-
Field1 Field2
A 2
A 22
A 44
A 57
B 45
B 12 etc
Thanks