Forum Discussion
Use GROUPBY in Excel to add Blank Rows/Cols After Each Group
Use GROUPBY in Excel to add Blank Rows/Cols After Each Group to add blank Rows: =LET( a, GROUPBY(B4:D13, E4:F13, SUM, , 2), DROP(IF(BYROW(--(a = ""), SUM), "", a), -2) ) to add blan...
Nice idea. If to use logic directly
=LET(
a, GROUPBY(B4:D13, E4:F13, SUM, , 2),
DROP( IF( BYROW( a = "", OR ), "", a), -2)
)- many thanks for this great contribution
