Alteryx Designer put headers in different places

[krmplt]

Hello everyone,

I have an excel input that comes in the following format:

Date	Work Received	Word Done
01/11/2019	33	30
02/11/2019	27	25
03/11/2019	32	32
04/11/2019	12	11
05/11/2019	85	83

However, I need to make a report with this data in this format:

	01/11/2019	02/11/2019	03/11/2019	04/11/2019	05/11/2019
Work Received	33	27	32	12	85
Word Done	30	25	32	11	83

I have tried to use the transpose tool, but I'm not able to get the expected result, does anyone have any suggestion on how to achieve this?

[benakesh]

Hi @krmplt ,

You may need more than one transpose/cross tab tools .

[krmplt]

Hi benakesh,

Thank you very much for your help.

However, when I open the workflow you attached I only see this:

Have you got any idea, of what's going on?

[Jonathan-Sherman · Accepted solution]

Hi,

This should achieve the changes you're looking for:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[krmplt]

Hi @Jonathan-Sherman

Worked like a charm!

Thank you very much

[benakesh]

Hi @krmplt ,

Sorry , edited my original reply and attached correct wf.