Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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