Transpose Vertical to Horizontal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I currently have a database table with records that need to be transposed to Horizontal fields based on the unique identifyer in the first field i.e

Field 1 Field
-------- ----------
1
1
1
1
2
2
2
2

TRANSPOSED TO

FIELD 1 FIELD 2 FIELD 3 FIELD 4 FIELD
-------- -------- --------- -------- --------
1 A B C
2 A B C

can someone suggest how i can do this

thanks
 
MIke said:
Hi
I currently have a database table with records that need to be transposed to Horizontal fields based on the unique identifyer in the first field i.e.

Field 1 Field 2
-------- -----------
1 A
1 B
1 C
1 D
2 A
2 B
2 C
2 D

TRANSPOSED TO:

FIELD 1 FIELD 2 FIELD 3 FIELD 4 FIELD 5
-------- -------- --------- -------- ---------
1 A B C D
2 A B C D
Click to expand...

Perhaps a cross-tab query will work. See the Access Help article
"Create a select or crosstab query."
 
Back
Top