Splitting a column into two different column in Alteryx.

[kiotsuresh]

I'm Having the Data as below,

Category

Home

Furniture

Dining

Office

Printers

Laptops

Library

Books

Pens

And So on...

I need to split this "Category" column into Two Columns "Category1"and  "Category2" .

Output:

Category1	Category2
Home	Furniture
Home	Dining
Office	Printers
Office	Laptops
Library	Books
Library	Pens

Can Somebody help on this please?. After splitting into two I need to left join both the output(which I'm aware).

[IraWatt]

Hey @kiotsuresh,

Cross tab is tool to go too when you want to make rows into column headers:

Any questions or issues please ask :)
HTH!
Ira

[binu_acs]

@kiotsuresh One way of doing this

[kiotsuresh]

I have Data like this,

Name

Suresh

     Kumar

Ram

     Rajesh

and so on. will this solution work in this case?

[IraWatt]

@kiotsuresh Does the extra spaces mean its a second name?

[binu_acs]

@kiotsuresh updated the workflow 

[kiotsuresh]

Have Updated my Query

[kiotsuresh]

I have Updated the Post Sir.

[IraWatt]

Hey @kiotsuresh,

Heres one way to do that:

[binu_acs]

@kiotsuresh one way of doing this