Moving values from cell below to the cell next to

Hi,

I have a bit of a puzzling problem.

I have a large set of data in Access part of which appears as follows:

Field 1, Field 2
Data A
Data A1
Data B
Data B1
Data C
Data C1 etc..

I would like to move the A1, B1, C1 etc. from the row below, to become adjacent to the A, B C etc. so that in the end I have data as below:

Field 1, Field 2
Data A, Data A1
Data B, Data B1
Data C, Data C1
etc..

Does anyone know how to do this? (I hope I explained it well, please let me know if I can make it clearer)

Thanks,
Allan

One question. is there a really easy way to identify which to rows go together (other then it is located on after the other)?

If you can only identify them one after the other then I would do it this way

1. You will create a temp table with the fields you need.
2. You will write VBA code (using DAO or ADO) to open the Org Table and loop through it. You will take the first row and put it in the first filed of the new table and you will take the second row and put it in the second field of the new table. You will loop through untill you are done.

try writing the VBA code and let us know if you need help.

The reason for the first question, is becuase if the is a way to identify which two rows go together, we might be able to write a SQL statement to do what you want. To do this you have to be able to identify every row that will go into field one of the new table and link that to the secondary item (row) that will be going into field2 of the new table.

S-