Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting data from a pasted document | Excel Worksheet Functions | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Lists | Excel Worksheet Functions | |||
Data Validation Lists | Links and Linking in Excel |