VJ Reddy - i'd like to thank you for your help, but i solved this by doing the following:
int introwCount = 1;
foreach (DataRow dr in LIPSdb.dsResults.Tables["tbl_Daily_Timesheet"].Rows)
{
gintRow++;
for (C = 1; C < intColumns; C++)
{
if (dr[2].ToString() != "")
{
if (introwCount == 1)
{
ws.Cells[gintRow, gintColumn + C] = dr[C].ToString();
}
else
{
ws.Cells[gintRow, 8] = dr[8].ToString();
ws.Cells[gintRow, 9] = dr[9].ToString();
ws.Cells[gintRow, 10] = dr[10].ToString();
ws.Cells[gintRow, 11] = dr[11].ToString();
ws.Cells[gintRow, 12] = dr[12].ToString();
ws.Cells[gintRow, 13] = dr[13].ToString();
ws.Cells[gintRow, 14] = dr[14].ToString();
ws.Cells[gintRow, 15] = dr[15].ToString();
ws.Cells[gintRow, 16] = dr[16].ToString();
ws.Cells[gintRow, 17] = dr[17].ToString();
ws.Cells[gintRow, 18] = dr[18].ToString();
ws.Cells[gintRow, 19] = dr[19].ToString();
}
}
if (dr[2].ToString() == "") ws.Cells[gintRow, gintColumn + C] = dr[C].ToString();
}
introwCount++;
if (introwCount > 3)
introwCount = 1;
}