Manipulate how data is displayedQuestion:
In the attached Excel 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.
If a solution can be given in MS Access that would be acceptable too.
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. EE01.xlsx