Transpose with comma as separator

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.

Transpose.png

workflow.png

Workflow

Accepted answers

grazitti_sapna

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.

All comments

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.

concatmockup.yxmd

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.

2020-07-14_14-35-57.png

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703