Thanks for all your help! I really appreciate it.

I have one column with duplicate entries:

Column1

A

A

B

B

B

C

I'd like to create a new column that generates a counter within each duplicate record.

Column1 NewColumn

A ...

This works!!! Thanks. I have another question:

Do you know how to pivot transform the data so that it looks like this:

Unpivoted Data:

Column1 Column2 Column3

A ...

Sorry I got column2 data wrong. I'm actually trying to get the following data values in Column2:

Column1 Column2

A ...