I have a document with horizontal lines of data that contain agent assignments and priorities for each assignment. What I would like to do is be able to view in a chart or pivot or other, the agents assigned to particular companies and the subsequent priority.
The goal is to be able to quickly select the company from a pivot or dropdown or other and identify which agents are assigned to that specific company and their priority. The full data I'm working with is over 240 columns and about 1500 lines of data
Bookmarks