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 ...

Formulas and Functions

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

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

Resources