formula for getting different sets of data entered

can anyone help me in this col.1| col.2| col.3 A | A | SET1 A | B | SET2 B | A | SET3 A | B | SET2 C | B | SET4 B | A | SET3 C | B | SET4 And so on... how can i get get different sets in co...