basta una soluzione del genere

<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<%while not rs.bof and not rs.eof%>
<tr>
<td width="50%"><%=rs(1)%></td>
<%rs.movenext
if not rs.bof and not rs.eof then%>
<td width="50%"><%=rs(1)%></td>
<%else%>
<td width="50%"></td>
<%end if%>
</tr>
<%wend%>
</table>