agwalsh
asked on
Creating a matrix from a list - pivot table or formula?
hi Folks
I want to create a matrix of values from a list. On attached file it's the data sheet, I want it laid out like desired layout sheet. I've experimented with using index and match/match but it looks as though I can't easily copy that. A pivot table would be easier but it adds up the UEF numbers on days where a crew member is working on the same job twice instead of just showing it once....any ideas?
EE-Job-name-question.xlsx
I want to create a matrix of values from a list. On attached file it's the data sheet, I want it laid out like desired layout sheet. I've experimented with using index and match/match but it looks as though I can't easily copy that. A pivot table would be easier but it adds up the UEF numbers on days where a crew member is working on the same job twice instead of just showing it once....any ideas?
EE-Job-name-question.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER