I am looking to create a table similar to the table below
A | 1 |
2 | |
3 | |
4 | |
5 | |
B | 6 |
7 | |
C | 8 |
9 | |
10 |
from data that looks like this
A | 1 |
A | 2 |
A | 3 |
A | 4 |
A | 5 |
B | 6 |
B | 7 |
C | 8 |
C | 9 |
C | 10 |
In my attached workflow, an IF statement via the Multi-Row Formula comparing one row to the row above it gives the following:
A | 1 |
2 | |
A | 3 |
4 | |
A | 5 |
B | 6 |
7 | |
C | 8 |
9 | |
C | 10 |
Solved! Go to Solution.
Hey @BradBaker
One way to accomplish this would be to use your Multi-Row Formula tool to create a third column that is 1 if the value in your first field changes and 0 otherwise. Like this:
iif([Row-1:Field1]=[Field1],0,1)
From there, just add a normal Formula tool that says if your new field is a 0, make your original field blank and otherwise keep it the same value. Like this:
iif([New Field]=0,"",[Field1])
Hope this helps!
Thanks @Kenda . That does work. Still looking for something that wouldn't require a workaround - something like changing the settings in the Summarize tool, but this definitely works.