Access / Excel DB Question

[jk3210]

In an Access database or Excel spreadsheet, is there any way to get a data set like in the first example (repeating Name records in Field1 due to additional data contained in other fields)

ID Field1 Field2 Field3

1 Name1 data data
2 Name1 ---- data
3 Name1 ---- data
4 Name2 data data
5 Name2 ---- data
6 Name2 ---- data
7 Name3 data data
8 Name3 ---- data
9 Name3 ---- data

and move that data to additional fields, so there is only one record per field1 Name, like below:

ID Field1 Field2 Field3 Field4 Field5

1 Name1 data data data data
2 Name2 data data data data
3 Name3 data data data data

[iamlost]

I haven't used Access for years but ...

Checkout multiple value field and crosstab queries in your Access Help menu or at microsoft.com

[jk3210]

Thanks. I gave both a try, but no help. Looks like I'm down to hand-editing 263,000 records.