Hi guys, how can we transpose the title on top to columns? a sample of how the data looks is attached
Is this what you are looking for?
@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/975775#M3195
I couldnt find the steps that i need ... this is how i want the output to look like
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
Here you go
The values ??that you have as desired I cannot know which formula you used
I have a created an excel file with two sheets, input and output.