I have an input file that gives me the following data -
Below is my desired output in Tableau with colors for conditions based on counts in each column....
Go to Data Source Tab and Select Test1 and Test2 columns and click on pivot option:
Your data will look something like below Screenshot :
Go to sheet and create below view:
Hope this helps!!
Retrieving data ...