Forum Discussion
mrs070
Jun 17, 2025Copper Contributor
Summarize multiple columns of varying row lengths into one column.
I am copying old data into into Column B and add my own findings to Columns D and G. I'm looking to summarize the data as depicted in columns P&Q. What I've got making the M&N columns is M:...
OliverScheurich
Jun 17, 2025Gold Contributor
=IFNA(DROP(REDUCE("",UNIQUE(SCAN("",A4:A8,LAMBDA(a,b,IF(b="",a,b)))),
LAMBDA(u,v,VSTACK(u,HSTACK(v,TOCOL(FILTER(B4:G8,SCAN("",A4:A8,LAMBDA(a,b,IF(b="",a,b)))=v),1,TRUE))))),1),"")
This function works with Excel online and Excel 2024 and Office365. If you work with legacy Excel such as Excel 2013 you can log on to your Microsoft account and apply the latest functions in Excel online. I bought Excel 2013 approx. 10 years ago and i can work with Excel online and use the newest functions.