Forum Discussion
Transposing Formula
Hello, Can someone please assist with a formula duplicating attached/below example of going from a vertical list of data to a horizontal grouping?
In D1
=UNIQUE(A:A)And then in E1
=TEXTJOIN(", ",,FILTER(B:B,A:A=D1))and fill down.
to avoid the extra "0" and such you can replace the ranges A:A and B:B with actual range where the data is or use SORT to force the "0" at the end and ignore it
