Transpose multiple fields in alteryx

[fbdsyd]

I'm trying to transpose the following:

A              |month   | balance

Sales       | 02        |  98732

Cost         | 01        |  65468

Expense  | 03        |  8543

Sales       | 01        |  98732

Cost         | 02        |  65468

Expense  | 02        |  8543

so that it ends up with:

month   |Sales       | Cost         |  Expense

01         | 98732     | 65468       |

02         | 98732     | 65468       | 8543

03         |                |                  | 8543

how do i make this transpose work in alteryx?

[Emil_Kos]

Hi @fbdsyd,

Cross tab is a tool to use.

Please find attached a workflow that I have prepared.

If my post was helpful please mark as an answer! 

[messi007]

Hi @fbdsyd,

You can do that with Cross tab

Hope that helps !

Regards,

[atcodedog05]

Hi @fbdsyd 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Emil_Kos]

Hi @fbdsyd,

If our solutions have been helpful please mark as a solution!

Good luck!