I have an excel spreadsheet which, on sheet two "users" has a list of username/role combinations. Each username is listed multiple times, depending on how many roles they have, there are 3291 entries total.
I would like this re-organized on sheet 1 "matrix", so that each user is listed once, with an "x" in their row under each role that is listed for them on sheet two "users".
I am a freelance computer scientist with vast experience in excel, I fully understand the project and can start immediately and have it complete within 2 days. Most of by previous projects were similar work and feedback can be seen on my profile. I look forward to hearing from you.
Aaron