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?
Solved! Go to Solution.
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
Perfect!!
Thank you.
Could you tag our post as "solution" (you can star them") so people know that you had a solution to your question.
Thank you !
Done!
Hello, which solution worked out for you? Could you please point me out the solution as i am also having same issue and the data is too huge.