In the attached file, Sheet1 shows how my data is currently laid out. I would like to change the layout to how it is shown in Sheet2. In Sheet2 the sequence of the rows does not matter.
Can this be done in MS Access?
Note that the data in my "real" file has a lot more rows and columns of data than the sample data in the attached file. Thanks.