Transpose/Cross tab tool Configuration

[LorenzTaylor]

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.

[LorenzTaylor]

hanks for the assistance @OllieClarke @mceleavey @binuacs