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

data such as
1 1000
1 1500
1 2500
1 3500

into 1 1000 1500 2500 3500

thanks in advance