The excel sheet I currently have contains ~500 records which looks something like the attached:
How can I invert this to group the objects by user?
User2 O1
O3
O4
Any suggestions? A cell with the users names could have up to 30 names. Just the logic of how I'd do this is boggling me.
Do I need to code this or could it be done with pivot tables?
Bookmarks