example entries
column1
BAS
KRK
IOF
IOF
BAS
IOF
my solution should be
column1 | column2
BAS | 1
KRK | 1
IOF | 1
IOF | 2
BAS | 2
IOF | 3
how can i add a column with autoincrement counting the entries from column 1 ?