I have a hierarchy in pivot table so many like A TO B TO C AND C TO D

[#1]

I HAVE  A PIVOT TABLE LIKE

KP11  KP12  KP13

A         B         D

A         C         F LIKE

BUT I WANT TO RESULT

KP11  KP12

A         B

B         D

C        F LIKE

ANY BODY PLEASE HELP ME:)

[lakshmikandh]

can you share the sample data ?