Transpose or Cross Tab Configuration Assistance

[LorenzTaylor]

Hello All -

I'm currently trying to determine the most efficient way to display data in the Alteryx workflow. I have a set of data that needs to be displayed in a certain way. First, I tried to configure the Transpose tool and connect the output directly to the Cross tab tool. I have tried multiple configurations but still unable to get the desired output. Please see attached excel file for an example.

[cjaneczko]

The complexity comes with putting the name at the top. You're going to need to use a bunch of reporting tools to do that. I would take a look at this article.

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-2/ba-p/9787...

A Transpose and Cross Tab gets you part of the way there. The rest, I would look at the above link.

[Bobbyt23 · Accepted solution]

I think you have 2 output options;

Name as a column:

Name as part of header:

[binuacs · Accepted solution]

@LorenzTaylor one way of doing this