Direct probe of Mott-Hubbard to charge-transfer insulator transition and electronic structure evolution in transition-metal systems