Oh I think I got it. I had to replace the 0 with the respective column. Thank you @Sudharsan_Ka
Dt1.AsEnumerable().Where(Function(s) Not “2022 1Q,2022 2Q,2022 3Q,2022 4Q”.Contains(s(0).ToString)).CopyToDataTable
One last question:
How can I replace “2022 1Q,2022 2Q,2022 3Q,2022 4Q” with variables e.g fiscalYear + " " + “1Q”.
Do I have to surround it with brackets?