separate result with different criteria

Hello there, i would like to separate the result that were pulled

before the result are combined with red item and blue item

i would like to separate it so it will be item no for Red and item no for Blue for the output

please help me for this, thank you

Will be used for online spreadsheet

inside there is expected output on different sheet for what im looking for, please help me

The only formulas that I see on the Data sheet are in B28:B38, D28:D38, F28:F38 and H28:H38
For the first two ranges:

Formula:

Please Login or Register  to view this content.

For the second two ranges:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.