I have a report that isn’t formatted very well for actually getting any information out of the report. I’ve shown an example of how the thing is formatted below.
Category1 Category4
Category2 Category5
Job # Category3 Category6
----------------------------------------------
123456 Excellent Poor
Excellent Fair
Excellent Good
This is repeated for 124 job numbers. What I’m looking for is an easy way to get the data into the following format:
Job # Category1 Category2 Etc...
------------------------------------------------------
123456 Excellent Excellent Etc...
Any excel guru’s out there know of an easy way to do this?