Forum Discussion
Solved
Look up and removing duplicates
Hi, hopefully someone can help me with this, I'm fairly new to excel and can't figure out how to make this work. Thank you!
Let's say the table is called DemoTbl.
You could use this:
=BYROW(DemoTbl[[AAL]:[LPA]],LAMBDA(each_row,TEXTJOIN(",",1,UNIQUE(each_row,1))))
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table. This solution works in legacy Excel such as Excel 2013 and in modern Excel.