Thread: [Solved] Extract data from many cells into 1 cell
View Single Post
 
Old 06-09-2023, 01:45 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Try the single-celled formula:
Code:
=BYROW(UNIQUE(Table1[tableName]),LAMBDA(tn,tn & "," & TEXTJOIN(",",TRUE,FILTER(Table1[ColumnName],Table1[tableName]=tn))))
2023-06-09_094502.jpg


A little shorter:
Code:
=BYROW(UNIQUE(Table1[tableName]),LAMBDA(tn,TEXTJOIN(",",TRUE,tn,FILTER(Table1[ColumnName],Table1[tableName]=tn))))
I'm sure it could be streamlined more…


Edit: Apologies! I just saw you're using Excel 2016.



Reply With Quote