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. ...
Assuming you are on Excel 365, as variant if not to split S/N by columns but keep as text list
with formula
=LET(
tagList, TOCOL( UNIQUE(tags), 3),
relatedSN, MAP(tagList, LAMBDA(t, TEXTJOIN(", ",, FILTER( SN, tags=t) ) ) ),
VSTACK(
{"Tag","S/N"},
HSTACK(tagList, relatedSN )
)
)