Forum Discussion
How to return multiple values from a table into a single cell?
I have a large data set in the format of the table below with a bunch of X's and I need to create a list of all the "Stores" and the services / products they provide in one cell (see rows 10 - 13 for what I need). The data set I am working with is far too large to do this manually so is there a formula that I can use to get this result?
1 Reply
=HSTACK(A3:A6,BYROW(B3:F6,LAMBDA(y,TEXTJOIN(",",,FILTER(B2:F2,y="x")))))
With Office 365 or Excel for the web you can use this formula.
