Headers into rows challengingg

[ShahdMuhaisen]

Hi guys, how can we transpose the title on top to columns? a sample of how the data looks is attached

[geraldo]

@ShahdMuhaisen 

You have to use the reporting tools.

this link has some step by step examples

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-1/bc-p/9757...

[ShahdMuhaisen]

I couldnt find the steps that i need :/... this is how i want the output to look like

[geraldo]

@

Sorry, I thought you would like to assemble an excel in the form of the example you passed with merged columns.

If you can send an excel that this sample you put in the print I set up a workflow to facilitate the construction

[ShahdMuhaisen]

Here you go :) 

[geraldo]

@ShahdMuhaisen 

The values ??that you have as desired I cannot know which formula you used

[ed_hayter · Accepted solution]

Is this what you are looking for?

[ShahdMuhaisen]

I have a created an excel file with two sheets, input and output.

[ShahdMuhaisen]

YES thanks !!