Remove Duplicates in a table

[BradBaker]

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

[Kenda · Accepted 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!

[BradBaker]

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.