how to remove duplicate record while paging in SQL Server

hi

this is Order_Users  table in database I bind gridview from this table:

as you see in above table id 1,2,3 has same peygiricode

below is storeprocedure:

USE [Digimaster]
GO
/****** Object:  StoredProcedure [dbo].[NewOrder_Information]    Script Date: 10/22/2016 21:45:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[NewOrder_Information]
		@PageIndex INT = 1
        ,@PageSize INT = 5
        ,@RecordCount INT OUTPUT 
 
AS
BEGIN
      SET NOCOUNT ON;
      SELECT ROW_NUMBER() OVER
      (
            ORDER BY [date] asc
      )AS RowNumber
     ,id
     ,PeygiriCode
     ,Quantity
     ,Tell 
     ,Name
     ,PostType
     ,[date] 
     ,[state]+' - '+city+'-'+' منطقه:'+zone as address
      INTO #Results
      FROM Order_Users 
      SELECT @RecordCount = COUNT(*)
      FROM #Results       
      SELECT * FROM #Results
      WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1    
      DROP TABLE #Results
END

and:
 
  private void GetDocumentInfo(int pageIndex)
    {

        using (SqlConnection conn = General.GetConnection())
        {
            using (SqlCommand cmd = General.GetCommand("NewOrder_Information", conn))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
                cmd.Parameters.AddWithValue("@PageSize", PageSize);

                cmd.Parameters.Add("@RecordCount", SqlDbType.Int, 4);
                cmd.Parameters["@RecordCount"].Direction = ParameterDirection.Output;
                conn.Open();
                SqlDataReader idr = cmd.ExecuteReader();
                if (idr.HasRows)
                {
                    GridView2.DataSource = idr;
                    GridView2.DataBind();
               
                }
                else
                {
                    GridView2.DataSource = idr;
                    GridView2.DataBind();
                }
                idr.Close();
                this.PopulatePagerP(Convert.ToInt32(cmd.Parameters["@RecordCount"].Value), pageIndex);

            }
        }
    }

I bind gridview from this table so according above SP it will show all 4 rows from table in gridview but I want it show id 1,2,3(with same peygiricode) in one row in gridview like:

how I should change SP to show row with same peygiricode in one row of gridview?

Best regards

Neda