Use GROUPBY in Excel to add Blank Rows/Cols After Each Group

Question

Use GROUPBY in Excel&nbsp;to add Blank Rows/Cols After Each Groupto add blank Rows:=LET(&nbsp; &nbsp; a, GROUPBY(B4:D13, E4:F13, SUM, , 2),&nbsp; &nbsp; DROP(IF(BYROW(--(a = ""), SUM), "", a), -2))to add blank Cols:=TRANSPOSE(&nbsp; &nbsp; LET(&nbsp; &nbsp; &nbsp; &nbsp; a, GROUPBY(B4:D13, E4:F13, SUM, , 2),&nbsp; &nbsp; &nbsp; &nbsp; DROP(IF(BYROW(--(a = ""), SUM), "", a), -2)&nbsp; &nbsp; ))&nbsp;&nbsp;

sergeibaklan · Answer

DrExcel_Excel_MVP&nbsp;
Nice idea. If to use logic directly
=LET(
    a, GROUPBY(B4:D13, E4:F13, SUM, , 2),
    DROP( IF( BYROW( a = "", OR ), "", a), -2)
)

drexcel_excel_mvp · Answer

many thanks for this great contribution

Forum Discussion

Use GROUPBY in Excel to add Blank Rows/Cols After Each Group

2 Replies

Resources