Data for Venn Diagram

[Anonymous]

I'm trying to create a Venn Diagram with the similar data example. My actual data ia referenced from 2 other tables. I'm hoping to achieve the end result in the 2nd picture in data format- so as to able to put into Venn Diagram to show the overlapping materials.

I've tried Group By and Pivot Column. The problem is Group By will take away some of the referenced columns that I would like to show. Pivot Column will not remove the duplicates in Material column...

Is there any way I can pivot in a way that I can show it in Venn Diagram, and have the Visual 'Table' next to it, so I can click a series of Materials, and the Venn can show the overlaps?

Raw DataEnd result

[v-yuta-msft · Accepted solution]

Hi FuzzyWazzy,

To achieve your requirement, click Query Editor-> Transform-> Pivot Column as below:

 

 

Regards,

Jimmy Tao