Transpose with comma as separator

[Jhayeanne012]

Hi,

I am working on a file where I have a list of references starting from A2 in a table and I need them to transpose horizontally and use a comma as a separator. I am new to Alteryx and not sure how to proceed.

I have attached my current data , my desired output and my current workflow.

Thanks in advanced.

[grazitti_sapna]

Hi @Jhayeanne012 , you might not be able to transpose data after using basic table tool as it displays you result as a table and also the output you desire is an output for crosstab tool. Here is a mockup workflow for your understanding,I hope it helps.

Thanks.

[Jhayeanne012]

Hi Grazitti,

This worked for me. Thanks!

But how do I output this to a specific sheet of excel? Attached is a screenshot of my workflow. When I run this, I get a blank sheet under "Formula" worksheet.

[grazitti_sapna]

Hi @Jhayeanne012 , can you show me the configuration of your output tool? 

Thanks.

[Jhayeanne012]

---

@grazitti_sapna wrote:

Hi @Jhayeanne012 , can you show me the configuration of your output tool? 

Thanks.

---

Hello! Please see attached. I may be missing some functions as we are still using Alteryx 2018. 😐

[grazitti_sapna · Accepted solution]

Hi @Jhayeanne012 , the configuration looks fine.Please have a look at my configuration.

Please check if that specific part of your workflow is outputting any data or not after the cross tab tool.

Thanks.