Cross Tab with multiple rows

FabioP

Hello everyone!

       Follows my need.

This is my input:

Desired output:

I don't know if is possible to config the Cross Tab tool to do this.

Could you guys help me?

LukeM

Hi @FabioP,

Attached is the solution.

1. Use Multi Row Formula tool to assign a Row number each time the A1,B1,C1... starts again.

2. Crosstab using the new Row number to group each separate row.

3. Deselect the Row column.

Hope this helps and you can apply it to your use case. Let us know how you get on.

Luke

CrossTabHelp1.yxmd