See attached, I think this will get you what you are looking for (though slightly different format than how you've displayed above). I'm assuming that what you want is the different uses across the top, and than an indicator of whether or not that material is needed for that use case. So in my example results, it's showing a count of 1 for every use, rather than the 1 2 3 that you are showing (since 1 2 3 would be your column headers instead).
1. Summarize by Material & Use, then count Use
2. Crosstab with Group by Material, Use as column headers, and Count as values.
Let me know if this gets you what you need!