sort data (smallest to largest) with formula (index - match)

Problem

I have been attempting to sort data which contains formula using a filter however I have not been able to do so. The column I am trying to sort contains the formula "=IFERROR(INDEX('Sharpcloud '!A:A,MATCH('Trend Connections'!B2,'Sharpcloud '!B:B,0)),"")". This column ideally should also re arrange columns B and "C to D".


where to find the column

This can be found in the event connection tab. Column A otherwise known as external ID. Essentially I want the filter to have 78, 79, etc while also re arranging trend and connection respectively.

Possible solution

pivot table?

Please find the spread sheet enclosed within.