Create new columns with multirow data cross tab

[YanishDewan]

Hi , 

I am trying to create new columns using the cross tab functionality however I am not able to achieve the desired results. I am not sure if I am missing some steps here but this is the situation. I have the following dataset

Fields.Name	Fields.Types.Name
String 1	Type 1
String 2	Type 2
String 3	Type 3
String 4	Type 3

I want to get the following after the Alteryx operation: 

Type 1	Type 2	Type 3
String 1	String 2	String 3
		String 4

During the cross tab operation, i am only able to concatenate all the strings into 1 single row and hence not able to achieve the desired table above. 

Any help will be much appreciated!

[CharlieS · Accepted solution]

Use a Tile tool (set to "Unique Value") to assign a sort of "grouped RecordID" field before performing the CrossTab and you're all set.

[RolandSchubert]

Hi @YanishDewan ,

assign a Id to the "Fields.Name" by group (e.g. using Multi-Row Formula tool), it should be no problem then.
See attached workflow.

Regards

Roland