so the data is like this:
Column A
Elment
Zr
Cu
Zr
Cu
Zr
Cu
Zr
Zr
Cu
Zr
Zr
Zr
Cu
Cu
Zr
Zr
Cu
Cu
Zr
Zr
Zr
Zr
Cu
Zr
Cu
Zr
Zr
Cu

ColumnB
type
1
1
1
1
1
1
1
2
2
2
2
2
2

as I mentioned there are tonnes of rows and I want the output as
Zu 2
Cu 1
Zr 2
Cu 1
......
and so on its like wherever I have Zr I want the type 2 and for Cu as 1.

thanks