Alteryx Format - Wrap a single column in the output

[sekhargvvs]

Hello,

I am having input data in the below format and the expected output is as below. Is there a way to wrap the "State" column in the output ? 

Details are in the below attached image.

Thanks

[ShankerV]

Hi @sekhargvvs 

Yes, Its possible with the Select tool and Summarize tool.

Proposing the workflow below.

Shanker V

[ShankerV]

@sekhargvvs 

Can you please share the input in the Excel format, so that I can post the solution for you now.

Shanker V

[sekhargvvs]

Thank you Shankar, please find the input file attached.

[ShankerV]

Hi @sekhargvvs 

Please find the below output. 

Hope this is your expected output. 

Finally achieved with table tool as Merger and Center option is not possible in Alteryx. 

Initially I got confused with the attachment name as WrapText. Actually its Merge and Center. 

Shanker V

[ShankerV]

@sekhargvvs 

1. Use the Input tool, input your file.

2. Use Table tool with below configuration

3. Use another Table tool with below config,

4. Use render tool to save the output as .xlsx format

Output file

Shanker V

[sekhargvvs]

Apologies for misspelling it, thanks a lot this gives the output i am lookin for.

[ShankerV]

Hi @sekhargvvs 

No worries.

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Shanker V