Concatenate entire row into one cell

[Alteryz]

Hello!

I am trying to condense a data set into one column. The problem is the number of columns will vary from week to week, sometimes I will have more than the 4 filled in columns in the screenshot, which is the reason the concatenate formula goes out to "bk". I was using the formula tool to simply add each column together however I want to automate this workflow and I wont be able to do that if I continue using the formula method. Does anyone know of a way to something similar to the below in alteryx?

[Paulteryx · Accepted solution]

Greetings!

I would give each record a Unique ID with the RecordID tool, then use the Transpose Tool with the RecordID chosen as the Grouping Field. From here I would use a Summarize, and Groupby recordID, and concatenate the other column.  Let me know if this helps, I can throw together a quick example if you need it :)

[Alteryz]

This is perfect thank you so much!

[txjohnnypops79]

Hello Kindly @Paulteryx I could use that quick example if you don't mind?