API Test automation Framework using TestNG

I have a test automation project where I access two sheets to run the tests. Eg. I have one sheet with all the testnames and respected run modes

Testname RunMode
Test1              y
Test2              y
Test3              n

I have another sheet with relevent test data for each test name.

Eg.

Test1
Testdata1 Testdata2 Testdata3....

I would like to pick only those testdata from second sheet of test names with run mode 'y' in the first sheet. And run tests for each test name individually . lets say Test1 has multiple rows of data, but I would like to run Test1 as an individual test.