GROUPBY Function And Merged Cells

Copper Contributor

How to Deal With Merged Cells in Excel if you want to summarize your data with GROUPBY 



here is my first try :



      TOCOL(B7:C24, , 1),
      LAMBDA(x, y, IF(y = "", x, y))

a Powerful use of my custom Excel function FILLDATA is demonstrated in situations like this, where the first two columns (which would be used as the Row Field in the GROUPBY function) have merged cells.
And that is the solution with FILLDATA Function :




=GROUPBY(FILLDATA(B7:C24, "d", , ), D7:F24, SUM)
 FILLDATA is a custom function built using LAMBDA  that automates the process of filling empty cells in your spreadsheets in all Directions (Down – Up – Right – Left )

If you want to know more about it , check out this Post :

if you find it useful , please vote for it:



0 Replies