Please try at F18
Formula:
=IFERROR(INDEX(Table1,AGGREGATE(15,6,ROW(Table1)/((Table1[Launch Date]=F$15)*(1+((Table1[Brand]<>Table1[[#All],[Brand]])+(Table1[Launch Date]<>Table1[[#All],[Launch Date]])>0))>{0,1}),ROWS(F$18:F18))-ROW(Table1[#Headers]),4+MOD(AGGREGATE(15,6,ROW(Table1)*100-{1,2}/((Table1[Launch Date]=F$15)*(1+((Table1[Brand]<>Table1[[#All],[Brand]])+(Table1[Launch Date]<>Table1[[#All],[Launch Date]])>0))>{0,1}),ROWS(F$18:F18)),-100)),"")
I couldn't figure out how to add space between brand.
I got it
Please try at F18
Formula:
=IFERROR(INDEX(Table1,AGGREGATE(15,6,ROW(Table1)/((Table1[Launch Date]=F$15)*(1+2*((Table1[Brand]<>Table1[[#All],[Brand]])+(Table1[Launch Date]<>Table1[[#All],[Launch Date]])>0))>{0,1,2}),ROWS(F$17:F18))-ROW(Table1[#Headers]),4+MOD(AGGREGATE(15,6,ROW(Table1)*100-{1,2,5}/((Table1[Launch Date]=F$15)*(1+2*((Table1[Brand]<>Table1[[#All],[Brand]])+(Table1[Launch Date]<>Table1[[#All],[Launch Date]])>0))>{0,1,2}),ROWS(F$17:F18)),-100)),"")
Bookmarks