Hello FDibbins,
in I3:L3 is not repeat value there also transpose value from B2:B6 based on C .
Now I am still trying to formula you suggest

thanks