Hello. Is there a formula I can use to generate the output below. Basically, for a matching value in column A, generate a list of values in column B.
Thanks for the assistance.
Thanks, could I use this when additional values are added to columns A and B on sheet 1? e.g. the ability to drag the cursor down to apply to new values added so the new comma separated lists are created?
Postscript:
Provided the names are defined so as to have space for the extended data, the correct results should be returned from this version of the formula.
yes
=UNIQUE(FILTER('sheet 1'!$A$1:$A$100,'sheet 1'!$A$1:$A$100<>""))
change the rows to max size
or you can just use ciolumn reference - but i dont like doing that
=UNIQUE(FILTER('sheet 1'!$A:$A,'sheet 1'!$A:$A<>""))
and then
=IF(A1="","",TEXTJOIN(", ", TRUE, IF(A1='sheet 1'!$A$1:$A$100,'sheet 1'!$B$1:$B$100, "")))