Transpose multiple fields in alteryx

Question

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 · Answer

Hi @fbdsyd,

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

Good luck!

atcodedog05 · Answer

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 😀👍

shape.yxmd

messi007 · Answer

Hi @fbdsyd,

You can do that with Cross tab

Hope that helps !

Regards,