need to take you back

i have an FR report in the typical Vertical format with departments coming one after the other

Admin

Electrical

Engineering 

i want this in horizontal format, the departments next to each other, column H, I, J for example ( as per pic attached)

issue is how or what is the correct formulas for the departments whose identifier is Segvalue2

in vertical format, the columns carry formulas like =FRAMTA("NETP") . now i need the FR to determine first that this is Admin department, then carry on to the =FRAMTA("NETP")