Hi... this might be a simple question and I am missing something obvious, but any help is appreciated...
I am trying to turn rows, with a Unique ID (like a username) and each with a categorical attribute (like Roles) into a Y/N type Matrix
Developer Admin Manager
User1 Y Y
User2 Y Y Y
Your help is greatly appreciated!
| chart count over User by Role
This will give you 1s and 0s that you can easily replace with Y and empty if you want to afterwards.
EDIT: removed first line of the query and replaced that with "yoursearch". The chart line is the important one though