Manipulate how Excel data is displayed
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will be posting a follow-up question to Glen's solution ,,,
ASKER