Concatenate with ; in between each term

[BillyL14]

Hi there

I need to change my data in row 3 to look like it does in row 4. Please see my sample.

How can I do that in Alteryx?

Thanks

[Emil_Kos]

Hi @BillyL14,

Hope this is helpful.

[David-Carnes]

Here's another way but @Emil_Kos 's solution is cleaner, IMHO.

[BillyL14]

@David-Carnes @Emil_Kos 

Thanks both for those, very helpful

I forgot to mention that I need the titles of the columns to also be combined, like in my updated sample, would that also be possible?

thanks again

[David-Carnes]

I'm sure @Emil_Kos will come up with something better, in the meantime...
Split out the Names and concatenate them, then Union the rest to it.

[David-Carnes · Accepted solution]

Same thing, but concatenate both field and value in the Summarize, then peel off the field names and data from each other and stack them with the Union tool set to Autoconfig by Position.

(edited to add file)

[Emil_Kos]

Hi @David-Carnes,

I don't think there is a better solution than the second one that you have proposed. Hope you don't mind as I have used your find to add additional functionality that might be useful for @BillyL14. 

In case you want the header to still be a header you need to use the dynamic rename tool to achieve that. 

[BillyL14]

@Emil_Kos @David-Carnes 

thanks both, what you gave me worked perfectly fr what I provided, however I should have mentioned that I would multiple lines of data, when I tried it took everything and put it in one line, it is possible to summarize as I have done on below example?

thanks again

[Emil_Kos · Accepted solution]

Hi @BillyL14,

Got it. This time it should work for you!

[BillyL14]

@Emil_Kos @David-Carnes 

Thanks both!