I am not even sure how to ask this question so I will show what I am trying to accomplish. I have table1 with data where the first field is repeated in multiple rows but the second field has unique values. The third field has data associated with field2 as such:
ID Field1 Field2 Field3
1 Joe Golf Red
2 Joe Baseball Red
3 Joe Running Blue
4 Bill Football Green
5 Bill Golf Yellow
6 Bill Tennis White
I am trying to write a query that can export to excel so the records display on the spreadsheet like this:
Row# Field1 Field2 Field3
1 Joe
2 Golf Red
3 Baseball Red
4 Running Blue
5 Bill
6 Football Green
7 Golf Yellow
8 Tennis White
I know this seems like a strange request, but I need to get the data from the Access 2003 table into the format below for an Excel file that will be used by other users.
Is this possible to do? Thanks so much for any help or suggestions