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!!