Forum Discussion
Multi-Row Data Consolidation Into Single Row, Multi-Column
I've been searching for a simple, easily repeatable solution to reformat a report that I generate on a biweekly basis. In column A, we have the asset tags of a primary piece of equipment. ...
=ifna(drop(reduce(0,unique(a2:a5000),lambda(x,y,vstack(x,torow(filter(b2:b5000,a2:a5000=y))))),1),"")