Create a two row header and pivot remaining data

[Kay327]

Hello,

I am trying to pivot my data, but I need two columns to be used as the header.

I would like to pivot the data based on the city and the car type.

Thank you.

[ArtApa · Accepted solution]

Hi @Kay327 - Here is what you can do:

[Kay327]

@ArtApa Thank you for all of your help!!

[john_watkins]

Here is just another way to look at it with one additional cosmetic tweak.   I am finding it useful in Alteryx lately to start by building the matrix of what I expect to come out at the end.  Then I simply join my various inputs back to that as my master list of combinations.  In your case, you find not each origin has all car types.