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], ""))

peiyezhu

Bronze Contributor

Mar 25, 2024

https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-to-conditionally-combine-columns-and/caad009a-0284-4263-b04a-a19c6037f2b5

Jpey65

Copper Contributor

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], ""))

Forum Discussion

Maybe an array formula to transpose records?

Resources