This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Gather all 9 clues to complete the final Weekly Challenge on Dec 16!
Looking to go from image 1 to image 2
Use a Summarize tool - group by Project, and select the Minimum of Score, then use Append fields to add that back to your data.
EDIT: Went too fast - Join instead of Append Fields so that the minimums come back appropriately, joining on Project
Use a Summarize tool to get the minimum for each project. Lastly, use a Join tool to append the minimum score back to your original data set.
Hope this helps!
Edit: I had previously said use a Transpose first, but that is unnecessary, as shown above.
Here is the sample workflow for your case. Hope this is helpful.