Forum Discussion
EXCEL FILTER
GIVEN CODE "G2" I NEED RESULT SAME AS TABLE 2, NOTE: JAN TO DEC BY ORDER BUT IF SAME MONTH REPEATED, CONTINUE THE SAME MONTH WITH THEIR DETAILS THEN FOLLOWED MONTH BY ORDER K...
Perhaps you want to consider a Power Query solution. Fairly easy by connecting to your data and the selected code in G2. Add a helper table with the 12 months in the correct order and merge it with the data and expand. Attached file contains a crude solution with no attempts to make it look nice.