Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Headers into rows challengingg

ShahdMuhaisen
6 - Meteoroid

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

8 REPLIES 8
geraldo
13 - Pulsar

@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
6 - Meteoroid

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

geraldo
13 - Pulsar

@

 


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
6 - Meteoroid

Here you go :) 

geraldo
13 - Pulsar

@ShahdMuhaisen 

 


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

ed_hayter
12 - Quasar

Is this what you are looking for?

 

Transpose Column Names On multiple lines.png

 

ShahdMuhaisen
6 - Meteoroid

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

ShahdMuhaisen
6 - Meteoroid

YES thanks !!

Labels