Access version of Transpose?

[Jimbob7]

Hi,

I've got two tables in Access. The first contains 300 column headers running from top to bottom, i.e:

Title
First Name
Surname
..
..

The second table contains the corresponding data entries for 1000 customers running from left to right, i.e:

MR Trevor Smith ....
MRS Mary Jones ....

Ideally i'd like to append table 2 to the bottom ot table 1 so the correct data field is under the right column header but I can't do this. Is there a transpose style funtion in access which will mean I can convert table 1 to run from left to right instead of top to bottom?

Thanks

J7

 

[Bat17]

I would paste it into XL to manipulate and shove it back in Access after if this is a one off. However you have a more fundemental problem as you have a max of 250 column headers in Access.

Your data may need normalising. quite a bit about it on this forum if you do a search

Peter