New to Alteryx, need help transposing

[jcornale]

I am looking to "kind of" transpose -- not sure what the correct lingo is.

This is the input data. (In practice there will be many more cities.

This is what I would like it to look like. 

I have also attached the Excel input file.

It's a long story as to why I need it like this, but I do. Any help would be GREATLY appreciated. Thanks you in advance!!

[Kenda · Accepted solution]

Hey @jcornale! You are correct that you are wanting the Transpose tool! I would suggest choosing City as a Key Field in the configuration. Then, use a Formula for the City field to concatenate like this:

[City]+" "+[Name]

You can then use a Select to get rid of the Name field and change the Value field to be called Amount. Hope this helps!

[NicoleJohnson]

Try Transposing your data first, and then use a formula tool to combine the City name with the column name that will then be showing up as the Name field!

NJ