how to transpose row data into column wise into new table in access

[alpeshkpatel]

data such as
1 1000
1 1500
1 2500
1 3500

into 1 1000 1500 2500 3500

thanks in advance

[alansidman]

Look at this:

http://www.ehow.com/how_7559154_conv...ta-access.html