add multiple unique header from SQL server in android -

i retrieving data sql server in listivew android:-

 connectionclass = new connectionclass();     lstcountry = (listview) findviewbyid(r.id.lstcountry);     string querycmd = "select  user_mst.name+'--'+dept_dispatch_code grpname,tl_no,ltr_nm_addrs, ltr_sub,'https://docs.google.com/gview?embedded=true&url=cg.nic.in/raipur/tlmis/upload/'+ fileuploading fileuploading\n"+             "from  letterrecord inner join user_mst on user_mst.user_id=letterrecord.dept_dispatch_code\n" +             "where  (ltrstatus_code = '1')  order dept_dispatch_code asc ,cast(tl_no int) desc";     try {         connection con = connectionclass.conn();         statement statement = con.createstatement();         rs = statement.executequery(querycmd);         arraylist<string> arraylist = new arraylist<string>();         arraylist<string> arraylist1 = new arraylist<string>();         arraylist<string> arraylist2 = new arraylist<string>();         arraylist<string> arraylist3 = new arraylist<string>();         arraylist<string> arraylist4 = new arraylist<string>();         while (rs.next())         {             arraylist.add(rs.getstring("tl_no"));             arraylist1.add(rs.getstring("ltr_nm_addrs"));             arraylist2.add(rs.getstring("ltr_sub"));             arraylist3.add(rs.getstring("fileuploading"));             arraylist4.add(rs.getstring("grpname"));         }          string[] mstringarray = new string[arraylist.size()];         mstringarray = arraylist.toarray(mstringarray);          string[] mstringarray1 = new string[arraylist1.size()];         mstringarray1 = arraylist1.toarray(mstringarray1);          string[] mstringarray2 = new string[arraylist2.size()];         mstringarray2 = arraylist2.toarray(mstringarray2);          string[] mstringarray3 = new string[arraylist3.size()];         mstringarray3 = arraylist3.toarray(mstringarray3);          string[] mstringarray4 = new string[arraylist4.size()];         mstringarray4 = arraylist4.toarray(mstringarray4);          mysqlmyadapter2 = new mysqlmyadapter2(collectordetail.this, mstringarray, mstringarray1,mstringarray2,mstringarray3,mstringarray4);         lstcountry.setadapter(as);      }     catch (sqlexception e)     {         toast.maketext(collectordetail.this , e.getmessage().tostring(), toast.length_long).show();     } 

and output below:-

enter image description here

and table below:- enter image description here

in list view there 1 field grpname repeating in every unique row want 1 unique header. how cane this?

solution 1 :

use sectioned recyclerview
https://github.com/afollestad/sectioned-recyclerview
https://github.com/intrudershanky/sectioned-recyclerview

solution 2 :

compare current item text previous item text, if both same, remove header text current view.

note : use of solution must have data arranged in group, cannot have data a,a,b,a,a,c,b should a,a,a,a,b,b,c