Hi

I have a set of raw data which i would like to arrange to the result shown as below

excel help.PNG

I have tried using pivot table, but i cant make the hierarchy the same for the Example Car, Motor, Boat shall belongs to under C.

Exvel help 2.PNG

Thanks for helping.