I have data table like below
| Id value |
|---|
| 1 |
| mat_type |
| silver |
| silver_ref |
| gold |
| gold_ref |
| iron |
| iron_ref |
From this data table I want to filter like below way
remove first 2 rows and if silver,gold,iron != ‘N’ and silver_ref,gold_ref,iron_ref = ‘Y’. So data table will become
| Id value |
|---|
| silver |
How can I achieve using linq