Formula for extracting data from across the table return values from multiple columns

[manish2303]

I have change type and change details(2 columns for each head).
I want to extract summary of filled cells.
I have shown output and input in picture as well as attached file.

Thanks in advance

Screenshot (122).png

[Bosco]

In "Output" B8, copied right to C8 and copied down :

=INDEX(IF(B$7="Change Type",$B$4:$C$5,$D$4:$E$5),MATCH($A8,$A$4:$A$5,0),AGGREGATE(15,6,COLUMN($A$4:$C$4)/($A$4:$A$5=$A8),ROWS($1:1)))

Regards
Bosco