SQL Server :: Traversing DB Tables / Fetch The Value Inside Each [row][column], And Overall?

I read some articles before posting to try and solve my issue but i didn't get anywhere,

Here is what i'm trying to do:

1) I have an excel sheet with 1 EntrantID column and the rest are numbers (these numbers refer to answer codes for certain questions),

So for example, my excel sheet looks something like:

ID --- a1 --- a2 --- a3 --- a4 --- a5 --- etc...

1 ---- 32 --- 55 --- 12 --- 121 -- 50---etc...

The goal is to traverse thru every row, and every column and according to a checking condition for the values of answers, i will add the number to one of two columns in another table, so for example, i will start traversing a1, i will check it's value which is 32, if 32 > 0 and 32 < 60, then i will add 32 to columnA in another table, else, i will add it to column B in that table, then i will move on to the next value, a2 which is 55, it's < 60 so i will 'add' it to that same columnA in that table..

At the end, my other table, the one with results should look like this:

PersonID --- columnA --- columnB

1 ------------ 32, 55, 12 --- 121, 50

Hope i didn't confuse things, i'm trying to explain as best as i can lol.

So what i did, i imported the excel sheet to sql server, and i looked up SQL language to see if i can do that thru SQL itself, and i couldn't find a way to traverse columns, so next, i started an ASP.NET project, connected to the DB and i drag/dropped the table in my page as a GridView, where i'm trying to traverse it so i can get the values, check them against the range, and insert them in relative column.

I tried something like this:

DataTable dt = new DataTable();
dt = (DataTable)GridView1.DataSource;
DataTable temp = new DataTable("MyTable");
for (int i=0; i < dt.Rows.Count-1; i++)
for (int k = 0; k < dt.Columns.Count-1; k++)
if ((int)dt.Rows[i][k] > 0 && (int)dt.Rows[i][k] < 50)
temp.Rows[i][k] = dt.Rows[i][k];

That is not working, and i'm unable to do it. basically, i don't know how to fetch the value inside each [row][column], and overall i don't know how i can do the required task.