Forum Discussion

Copper Contributor

Mar 20, 2024

Solved

Maybe an array formula to transpose records?

I have a table of data. Note that the number of rows per index can vary and the total number of unique index values will vary and not be named TestX: Index Concat Test1 DataValue1 Test1 ...

excel

Formulas and Functions

office 365

Jpey65
Mar 26, 2024
https://www.ablebits.com/office-addins-blog/textjoin-function-excel-merge-text-multiple-cells/#:~:text=The%20syntax%20of%20the%20TEXTJOIN,text%20value%20that%20you%20combine.

=TEXTJOIN(", ", TRUE, IF([Index]=[@Index], [Concat], ""))

OliverScheurich

Gold Contributor

Mar 20, 2024

Jpey65

=LET(ind,A2:A34,

conc,B2:B34,

HSTACK(UNIQUE(ind),IFNA(DROP(REDUCE("",UNIQUE(ind),LAMBDA(u,v,VSTACK(u,TOROW(FILTER(conc,ind=v))))),1),"")))

Does this return the intended result?