How to transpose & use cross tab

[Aggsneh]

Hi all,

I have data which needs to be transposed in different manner. Could you please help me with the same? Attached sample for your reference in which you can see the raw data and what output I need.

[messi007]

@Aggsneh,

Please see below :

Attached the workflow,

Hope this helps!

Regards,

[atcodedog05]

Hi @Aggsneh 

Here is my take using reporting tool. Check with more data and let me know if this is flexible.

Workflow:

Output:

Hope this helps : )

[Aggsneh]

Thanks Messi for the quick turnaround. It was helpful. But if we have more data to add in, we have to do some manual work.

[messi007]

@Aggsneh,

With dynamic rename if you will have more columns (like ccc, ddd) the workflow below will do the job:

Attached the workflow.

Regards

[Aggsneh]

Hi,

I tried using and looks it helped. I am facing one challenge. I have some headers as well in particulars which also should be in line in output. But with the alteryx you shared it 's showing all the headers only at beginning rows and after the remaining particulars. I have reattached the data for your reference what I have and what is required.

Thanks

[messi007]

@Aggsneh,

Below how you can do it

Attached the workflow.

If this solve the requirement please mark it as solved it will help others.

Regards, 

[Aggsneh]

@atcodedog05 : Could you please help here in your workflow how to have the desired output as attached? Iused your worklfow and showing the results but in different format s described in previous reply.