Transpose/Cross tab tool Configuration

Good Morning ALL -

I have a set of data that needs to be Transposed or either cross tab to achieve my desired output. The current out put has 4 Columns: [Month_Year], [EQ_INIT] EQ_NR] AND [EQ_INIT_NR].

I would like to group by the [Month_Year] and each month will have a separate column with EACH [EQ_INIT_NR]. It only allows me to Concatenate, First or Last when configuring the transpose. I've provided an example below. the outlines the current output of data and the desired output of data.

Alteryx Example.xlsx

Common Use Cases

Accepted answers

OllieClarke

A small tweak to @mceleavey is to use a recordid with a group by to make a row, rather than grouping by value in the case where there are multiple instances of the same value

LorenzTaylor.yxmd

mceleavey

Dammit @OllieClarke ,

I was just adding that in!

This should be correct.

binu_acs

@LorenzTaylor one way of doing this with the help of tile tool

Transpose_09062025.yxmd

All comments

mceleavey

Hi @LorenzTaylor ,

I'm not sure of your logic. What is the first column and why is it null aside from one cell?

What is the grouping? As in, what granularity is each row and why are there only 9 rows in your desired output?

LorenzTaylor

Hi @mceleavey that is for visual purposes only to clearly outline which columns need to configured. The number of rows is simply just for example purposes, In reality, each month will not have the exact amount of data. I Just want to ensure each record is represented once the data is tranposed and/or cross tabbed.

OllieClarke

A small tweak to @mceleavey is to use a recordid with a group by to make a row, rather than grouping by value in the case where there are multiple instances of the same value