Field: "Field Name" is 0 length (Error in CrossTab)

[CaWilliams]

Hi! 

I'm trying to use the CrossTab tool, but I keep getting the same error message: 

Field: "Favorite Color" is 0 length.

This specific field is not important and I'm fine with deleting it, so if you know how to delete a row from Alteryx that will work also.

For example, my data looks like: 

Name   Question               Answer

Joe       Favorite Holiday   Christmas

Joe       Favorite Color      [Null]

Joe       Favorite Food      Burgers

Jane     Favorite Holiday   4th of July

Jane     Favorite Color      [Null]

Jane     Favorite Food      Cheese

But I'd like my data to look like this:

Name    Favorite Holiday   Favorite Food

Joe        Christmas            Burgers

Jane      4th of July            Cheese

Thank you! 

[BenMoss · Accepted solution]

The cross-tab tool is definitely what you want to use here.

I don't get the same error as you, but maybe our configurations are different.

See attached example.

Ben