Seeking help on how to use IF ,Index+match transpose

[SUDARSAN]

Dear Friends,
I have task to complete

I tried to repeat value that MATCH and REPEAT

with Index(x:Y, match(x,x;y,0)) but it is not returning the multiple value
seeking your help on this

IF value is >= C4.. it should return Major first and ALL in next cell, IF value is <= C13... it should return ALL only

A26: N rows is lookup value with $A$4 : $A$23 and return $B4 times of $D$ 4: $D$23 Value in B26: N rows matching with A4:A23

and

according to the F4:F23, H4:AD23 match and transpose

for example
Plough
Arecanut
Banana
Cashewnut
like so.....
Cultivator
Arecanut
Banana
Cashewnut
like so


please help

Thank you in advance