Filter by merged cells dilemma

Hello -

I've attached workbook Filter by Merged Cells. Raw Data (tab) contains simple table, with column A containing merged cells. Expectation Mockup tab details outcome I am trying to build towards.

Problem: Use Filter tool in Excel to return all items in columns B to C, for item selected in A (column A contains merged cells).

Is there an easy way to achieve this? Since I cannot utilize Center Across Selection vertically, how can I return all items in column B to C, for single item in merged cell A?

Thanks,

-Ruppk825

Hello @Logit & @Carim - Thank you for your responses, both methodologies work and have their pros and cons. I appreciate you sharing your information and expertise. This issue can be considered closed.