Converting grid data to side-by-side lists
Hello everyone, this has been driving me crazy so want to see if any of you
have suggestions:
I have a grid in an Excel worksheet formatted like this:
Company A Company B Company C
Service 1 X X
Service 2 X X
Service 3 X X
I need to convert this data to a list that maps the Services to the
Companies like this:
Services Companies
Service 1 Company A
Service 1 Company C
Service 2 Company A
Service 2 Company B
Service 3 Company B
Service 3 Company C
I cant seem to find a good way to do this.
Any ideas??? Thanks all!
|