Inserting Subheader Rows into a Gridview & merge cells

Question

Team,

 

My requirement is to insert a new subheader in the gridview also merge similar cells

 

data is as follows:

id	posted_at	name	designation
124	ADMIN	SWATHI	SAO
234	ADMIN	NIVEDA	SAO
356	IS	RAM	AAO
789	IS	LATHA	AAO

 

GRIDVIEW display should be as follows:

id	NAME	DESIGNATION
ADMIN
124	SWATHI	SAO
234	NIVEDA
IS
356	RAM	AAO
789	LATHA