Array Grouping

Anyone help me with this cause Im stuck

Output so far in attached pic

I need to be able to loop thru the date so for for each new date it is displayed like the first colspan 3. Then each sector info corresponding to that date underneath.

The first line is right but cant get the next loop to work.

<cfset myarray=arraynew(2)>
<cfset myarray2=arraynew(2)>
<cfset myarray3=arraynew(2)>
<cfset myarray4=arraynew(2)>
<!--- Populate the array row by row --->
<cfloop query="GetUsers2">
<cfset myarray[currentrow][1]=sectorinfo>
<cfset myarray[currentrow][2]=dfrdate>
<cfset myarray[currentrow][3]=regoid>
</cfloop>
<cfset total_records=GetUsers2.recordcount>

<cfloop query="GetUsers3">
<cfset myarray2[currentrow][1]=sectorinfo>
<cfset myarray2[currentrow][2]=dfrdate>
<cfset myarray2[currentrow][3]=regoid>
</cfloop>
<cfset total_recordscib=GetUsers3.recordcount>

<cfloop query="GetUsers4">
<cfset myarray3[currentrow][1]=sectorinfo>
<cfset myarray3[currentrow][2]=dfrdate>
<cfset myarray3[currentrow][3]=regoid>
</cfloop>
<cfset total_recordscie=GetUsers4.recordcount>
<table border="1">
<tr>
<td align="center"><font size="-1">METRO CIC</font></td><td align="center"><font size="-1">CONVAIR CIB</font></td><td align="center"><font size="-1">CONVAIR CIE</font></td>
</tr>
<cfset Previousdfrdate = "">
<cfset Previousdfrdate2 = "">
<cfset Previousdfrdate3 = "">
<cfset Previousdfrdate = #dateFormat(MyArray[1][2],'mmmm d, yyyy')#>
<cfset Previousdfrdate2 = #dateFormat(MyArray2[1][2],'mmmm d, yyyy')#>
<cfset Previousdfrdate3 = #dateFormat(MyArray3[1][2],'mmmm d, yyyy')#>

<cfoutput>


<tr valign="top">
<td colspan="3" align="center"><b><cfoutput><cfoutput>#Previousdfrdate#</cfoutput></b></cfoutput><!--- ---></td>
</tr>
<tr valign="top">
<td>
<cfloop index="Counter" from=1 to="#Total_Records#">
<cfif Previousdfrdate NEQ #dateFormat(MyArray[Counter][2],'mmmm d, yyyy')#>

<b>#dateFormat(MyArray[Counter][2],'mmmm d, yyyy')#<br></b>
<cfset Previousdfrdate = #dateFormat(MyArray[Counter][2],'mmmm d, yyyy')#>
</cfif>
<font size="-2">#MyArray[Counter][3]#...#MyArray[Counter][1]##dateFormat(MyArray[Counter][2],'mmmm d, yyyy')#<br></font> </cfloop> </cfoutput> </td>


<td> <cfoutput><cfloop index="Counter" from=1 to="#Total_Recordscib#">
<cfif Previousdfrdate2 NEQ #dateFormat(MyArray2[Counter][2],'mmmm d, yyyy')#>
<b>#dateFormat(MyArray2[Counter][2],'mmmm d, yyyy')#</b><br>
<cfset Previousdfrdate2 = #dateFormat(MyArray2[Counter][2],'mmmm d, yyyy')#>
</cfif>
<font size="-2">#MyArray2[Counter][3]#...<a href="aaa">#MyArray2[Counter][1]#</a>#dateFormat(MyArray2[Counter][2],'mmmm d, yyyy')#</font><br></cfloop></cfoutput></td>

<td>
<cfoutput><cfloop index="Counter" from=1 to="#Total_Recordscie#">
<cfif Previousdfrdate3 NEQ #dateFormat(MyArray3[Counter][2],'mmmm d, yyyy')#>
<b>#dateFormat(MyArray3[Counter][2],'mmmm d, yyyy')#</b><br>
<cfset Previousdfrdate3 = #dateFormat(MyArray3[Counter][2],'mmmm d, yyyy')#>
</cfif>
<font size="-2">#MyArray3[Counter][3]#...#MyArray3[Counter][1]##dateFormat(MyArray3[Counter][2],'mmmm d, yyyy')#</font><br></cfloop></cfoutput></td>
</tr>
</table>


Your help much appreciated

Alvin44