Reworking data in a table

[vgersghost]

Hello:

I was handed a table where the data is layout like this:
Field 1 Field 2 Field 3
00050S 10-71434B 0.05
00050S 10-72855 0.003125
00050S 10-83105-6A 1
00050S 10-83126 1

and I need it to be like this:
Field 1 Field 2 Field 3 Field 4 Field 5 etc.
00050S 10-71434B 0.05 10-72855 0.003125

There has to be a simple way to rearrange the data other the copying and pasting. There are over 40,000 records.

thx for any idea or help.

 

[speakers_86]

I see that this value "00050S" repeats in field 1. Is it a primary key that repeats? If so, then I am sure you can make an append query to add it to a duplicate table.

 

[vgersghost]

The value "00050S" repeating in field 1 is not a primary key. There is none. I'm not sure what your getting at.

thx

 

[speakers_86]

Then I am afraid I dont understand what your trying to do. Based on your first post, it looks like you are merging records 1 and 2. Is that what you are trying to do, merge records containing equal values in field 1?

 

[vgersghost]

Yes that is Correct. I am trying to merge all the records. Just not sure how.
thx