how to create column and sub column

[Ekmi9]

Hello Everyone,

Need help on to create column and sub column.

input : column name is 1,2,3,6,7,8 like this 

Output 

appreciate your help !

Thanks in Advance !

[FrederikE]

Hey @Ekmi9,

Do you want this output in Excel? In Alteryx no such thing as a "sub column" exists. Merging cells also doesn't work. Alteryx is not really ment to be used for such a format (no data tool is). 

An Alteryx approach for something like this would be to create a column that contains A or B, instead of each column carring that value each row would do so. 

This does something similar: 

[sparksun]

If you really want to present your data in this way, you can use several reporting tools to achieve that.But it is not recommended because Alteryx is not a good reporting tool.

[Ekmi9]

@sparksun can i have this workflow please want to check how you join two table

[nagakavyasri]