New to Alteryx, need help transposing

Question

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!!

Alteryx Question.xlsx

Kenda · Accepted Answer

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!