From Vertical axis to horizontal axis

[JannicB]

Hello Alteryx Community.

I have an issue I don't manage to solve on alteryx.

I would like to switch lines to columns via an excel sheet and I don't know how to do that.

Please find attached an excel sheet with my request.

I thought that I can use pivot table button

[afv2688]

Hello @JannicB ,

You can do this for sure using the crosstab tool.

there is no data attached, if you share it with us I could do maybe help you

Regards

[JannicB]

The Antivius scan doesn't accept the file, so here are a print screen.

Thanks a lot

[afv2688]

Hello @JannicB ,

Is this ok?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[JannicB]

Thanks a lot @afv2688

It works now!

Do you know if it's possible to have multiple values in vertical axis?

like for example value & volume:

Year | Product | gender | age | W1 Value | W2 Value | … | W1 Volume | W2 Volume |....

2019 | GLOVE | MALE | adult | 10            | 20            | …  | 2                 | 4                  | ...

2020 | GLOVE | MALE | adult | 7              | 3              | …  | 1                 | 3                  | ...

[afv2688 · Accepted solution]

Hello @JannicB,

You could add another transpose and merge both with a join tool:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[JannicB]

amazing!!

Thanks a lot for your support.

it will change my alteryx life!

thanks again.

Best,

Jannic