The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Concatenate 4 rows

Richie059
7 - Meteor

Hey guys, so I'm trying to dynamically bring in the name of these columns from an excel sheet that may very from workbook to workbook. I already know how to dynamically isolate or select these rows from the rest of the data set but how can I can concatenate them to get the name in one row.

Thank you! and please reach out if you need additional information. 

 

Alteryx Rows Concat.PNG

 

 

1 REPLY 1
binuacs
21 - Polaris

@Richie059 One way of doing this with the help of Transpose and the cross tab tool

binuacs_0-1659979094147.png

 

Labels
Top Solution Authors