If there is only 2 rows this should work

<cfquery name="Query1" datasource="#application.dsn#">
select column 3 // replace with name of column 3
from TableName // replace with the table...

I'm kinda confused so you have a table column 1 column 2 column 3, row 1 row 2 row 3 row 4 row 5 and you want var1 to show row 1,3 and 5 and var2 to show row 2,4 and 6 ?

You can set the sql...