Data Consolidation - No VBA

Hi, please see attached with expected results.

I have a table of 'Trades' (C6:G30) where there are 5 possible results per trade. ie. For Trade 1 (A6) the corresponding data is C6:G6.

I would like a formula to consolidate this information into two sets - a set of "Longs" in I4H:M7 and a set of "Shorts" in P4:T7.

A Long is denoted by an "L" in Col B, and an "S" for a Short.

There are intentional gaps between trades ie. rows 7 - 10 etc.

The expected results have been linked to the appropriate cells so it is clear what data I would like the formula to reference.

Thanks very much for your help.