I am currently stuck trying to sort out how to sort data for a massive spreadsheet, and I am stuck. I have:
1. 160 employees across the USA
2. 11 Managers
3. 320+ Clinical Research projects
My boss wants me to import this into Map Point and show which of the 160 employees are working on which of the 320 plus Clinical Projects!
The main problem is that the clinical projects have a name and not a number, and when you add up all of the lines in Excel, there are over 14000 lines of data!
Is this a hard thing to figure out?
If someone can point me in the right direction, I would appreciate it greatly!
Thank you again